SQL> select * from dba_role_privs where granted_role='DBA';
GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
SYD DBA NO YES
SYS DBA YES YES
GOLDENGATE DBA NO YES
SYSTEM DBA YES YES
SQL> conn syd
Enter password:
Connected.
SQL> select * from user_sys_privs;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
SYD UNLIMITED TABLESPACE NO
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
SYD DBA NO YES NO
SQL> grant connect,resource to syd;
Grant succeeded.
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
SYD CONNECT NO YES NO
SYD DBA NO YES NO
SYD RESOURCE NO YES NO
SQL> conn GOLDENGATE
Enter password:
Connected.
SQL> select * from user_sys_privs;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
GOLDENGATE CREATE ANY DIRECTORY NO
GOLDENGATE DROP ANY DIRECTORY NO
GOLDENGATE UNLIMITED TABLESPACE NO
GOLDENGATE ALTER SESSION NO
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
GOLDENGATE CONNECT NO YES NO
GOLDENGATE DBA NO YES NO
GOLDENGATE GGS_GGSUSER_ROLE NO YES NO
GOLDENGATE RESOURCE NO YES NO