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 see the schema tables ..

664820Nov 10 2009 — edited Jul 23 2010
Hi ,

I have 3 schemas in my data base and I have created a role called test_ro wih "select" privilege.I have created a user called "test_app" and I have assigned this role to the user test_app.When i login with the user test_app i am not able to see any of the table in the table node. i am also not able to see the schema list like in TOAD.

Could some one let me know how can i select a particular schema and how can i see the list of tables.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2010
Added on Nov 10 2009
17 comments
10,503 views