Skip to Main Content
Forums

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!

dba_tab_privs vs all_tab_privs

71981May 5 2009 — edited May 5 2009
If we query all_tab_privs (as user SYSTEM) for a particular SCHEMA we get a different set of privs (just SELECT) than when we query dba_tab_privs (SELECT and INSERT, UPDATE) for the same OWNER.objects...why would that be?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2009
Added on May 5 2009
#general-database-discussions
4 comments
5,692 views