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>