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,