systems privs
I am trying to see the system privs granted via role to a user using the view dba_sys_privs, but it is not listing.
Am i missing something ??
-----------------------------------------------
SQL> connect / as sysdba
Connected.
SQL> grant DBA to scott;
Grant succeeded.
SQL> select * from dba_sys_privs where grantee='SCOTT';
GRANTEE PRIVILEGE ADM
-------- --------------------- ---
SCOTT UNLIMITED TABLESPACE NO
SQL>
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway