User Default Role
Making roles default to a user has some advantages, it automatically enables all privileges in the default roles when the user logs in.
Here we introduce how to check all default roles of an user.
SQL> select granted_role from dba_role_privs where grantee = 'ERPAPP' and default_role = 'YES';
GRANTED_ROLE
--------------------------------------------------------------------------------
CONNECT
DATAPUMP_EXP_FULL_DATABASE