1.

Which Default Database Roles Are Created When You Create A Database?

Answer»

CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES DATA dictionary view can be used to LIST all roles of a database and the authentication used for each ROLE.

The FOLLOWING QUERY lists all the roles in the database:

SELECT * FROM DBA_ROLES;
ROLE PASSWORD
CONNECT NO
RESOURCE NO
DBA NO
SECURITY_ADMIN YES.

CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role.

The following query lists all the roles in the database:


Discussion

No Comment Found

Related InterviewSolutions