Skip to content
Home » Oracle » How Oracle Check User Default Role

How Oracle Check User Default Role

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

Leave a Reply

Your email address will not be published. Required fields are marked *