Topic : Role Management

Parameters realted to roles


Answer :

Dba_roles
session_roles
dba_role_privs
user_application_roles
role_role_privs
user_role_privs
role_sys_privs
v$pwfile_users
role_tab_privs

Show Answer Discuss

What is a default role?


  • A role that requires a password.
  • A role that requires no password.
  • A role automatically enabled when the user logs on.
  • A role automatically assigned when the user is created.

Answer :

A role automatically enabled when the user logs on.

Show Answer Discuss

Who is the owner of a role?


  • SYS
  • Nobody
  • SYSTEM
  • The creator

Answer :

Nobody

Show Answer Discuss

When granting the system privilege; which clause enables the grantee to further grant the privilege to other users or roles?


  • PUBLIC
  • WITH PRIVILEGE
  • WITH ADMIN OPTION
  • WITH GRANT OPTION

Answer :

WITH ADMIN OPTION

Show Answer Discuss

What is role?


Answer :

A role is a set of group of privileges that can be granted to users or another role. This is a great way for database administrators to save time and effort.

Show Answer Discuss