Quote Originally Posted by davey23uk
dba_role_privs

dba is a role

Thanx for the Update


Why does it show only one system priv UNLIMITED TABLESPACE, but not the rest of the system privs granted via DBA ?

I am trying to list all the system privs granted to the user (irrespective of grant via Role or Direct)