Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to expand table (or 'any' object) node - permissions issue?

842783Feb 25 2011 — edited Mar 3 2011
I am the dba for a database and hence have access to the system user. When I connect to the db through SQL Developer, I can expand the table node under any user and list tables. As I can with any object node.

I now want to create an admin user that has restricted capabilities, one of which will be to view objects, such as tables etc..
(I will ultimately do this via a role to allow multiple users to have the admin capabilities, but for now have just created an admin_user userid).

However, when I connect to the database using this admin_user userid, I am unable to expand any object node.

I have played with different permissions, granting 'select any dictionary', 'select_catalog_role', 'select on dba_tables' but the user still can not view any objects via the appropriate node. eg. attempting to go to Other Users - username - Tables just shows nothing. (There are no filters).

However the admin_user can run a SQL command to view the tables. eg. Select * from dba_tables, will list all tables for all users within the database. So they DO appear to have the appropriate access.

So why can't they see the tables in the tables node?

Is there some piece of configuration within SQL Developer itself that I have overlooked?

Cheers
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2011
Added on Feb 25 2011
9 comments
562 views