Oracle Database Discussions

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!

Find the roles granted on tables in oracle 10g

792290Sep 5 2012 — edited Sep 6 2012

Hi,
I need to find what roles granted to what tables in a schema. I try to query dba_tab_privs but this will give what roles granted to tables, but i want to find what tables are missing these roles in a schema?
any help is appreciated.
Thanks...

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2012

Added on Sep 5 2012

#general-database-discussions

8 comments

1,111 views