Skip to Main Content

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!

USER__PRIVS

User235837 -OracleJul 25 2013 — edited Jul 29 2013

Hi All,

   i execute some Grants to user , but not able to view that grants whatever i gave in below stmt.

Please provide me correct views if iam wrong;

SQL> GRANT SELECT ON sys.dba_pending_transactions TO XXX;

SQL> set lines 200

SQL>  select OWNER,TABLE_NAME,PRIVILEGE from DBA_TAB_PRIVS where owner='XXX';

OWNER                          TABLE_NAME                     PRIVILEGE

------------------------------ ------------------------------ ----------------------------------------

XXX                     SQLN_EXPLAIN_PLAN              DELETE

XXX                     SQLN_EXPLAIN_PLAN              INSERT

1. Why sys.dba_pending_transactions not in this view ?

2. is that view iam checking is wrong view or GRANTS are wrong ?

please help on this...

Thanks,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2013
Added on Jul 25 2013
6 comments
575 views