Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Chapter 18. Managing Roles

Terms you'll need to understand:

• DBA_ROLES

• DBA_ROLE_PRIVS

• ROLE_ROLE_PRIVS

• DBA_SYS_PRIVS

• ROLE_SYS_PRIVS

• ROLE_TAB_PRIVS

• SESSION_ROLES

• DEFAULT ROLE

• SET ROLE

• DBMS_SESSION.SET_ROLE

• Grant

• Revoke

• Enable

• Disable

Concepts you'll need to master:

• Create roles.

• Modify roles.

• Control role availability.

• Remove roles from users.

• Use predefined rules.

• Remove roles from the database.

• Display role information from the data dictionary.

Finally, we come to the last topic that will likely appear on your OCP exam—managing roles. Roles are Oracle's way of lumping together many privileges to make maintaining users and their privileges simpler and more centralized. This chapter provides an overview of roles and the part that they play in a healthy database.