In Oracle Database 10g, I need to create a user with these permissions:
- user can access schema to be able to read table names and columns
- user can not select (get) any data from any table
Is this possible or is there a way for a workaround?
This question came from our site for professional and enthusiast programmers.
I'd create a procedure returning all tables/columns and grant access to that procedure:
Depending on what privileges the creating user (not the user you want to give access to) has and whether you want to allow the reading user to get the DDL for every table in the database or only for a certain subset, you might want to