SQL> select * from dba_role_privs where granted_role='DBA'; GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE ------------------------- --------------- --------- ---------------------------------- --------------- --------- - SYS DBA YES YES SYSTEM DBA YES YES |