jmodic gave me correct answer.

Regarding chao_ping's answer

Ive gone thru roles granted to exp_full_database.
i found at the end both are having same role ie HS_ADMIN_ROLE and it has no privileges.
what does it mean?

check out this o/p


SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXP_FULL_DATABASE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE NO YES
EXP_FULL_DATABASE SELECT_CATALOG_ROLE NO YES

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXECUTE_CATALOG_ROLE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE NO YES

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='HS_ADMIN_ROLE';

no rows selected

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='SELECT_CATALOG_ROLE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
SELECT_CATALOG_ROLE HS_ADMIN_ROLE NO YES

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='HS_ADMIN_ROLE';

no rows selected

SQL> select * from dba_sys_privs where grantee='HS_ADMIN_ROLE';

no rows selected