Skip to Main Content
Spotfire Ideas Portal

Oracle Data Connection - Limit available tables in database to user defined schema/object names

Even with a low privilege database user, objects in PUBLIC schema are still visible. The ability to limit the visibility of specific schema, and to limit the objects visible by name (pattern matching) would be useful

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Jun 26, 2018

      Why? This doesn't seem to add any value to be honest. If you don't want the Spotfire user to see anything other than tables/views relevant to Spotfire create a new schema user that only sees those and problem solved. It's not Spotfire's fault that you have objects which are visible to all schema users.