Role Information in the Data Dictionary

To find information in the data dictionary concerning roles, the following views are beneficial:

  • DBA_ROLES provides information on all the roles that exist in the database.

  • DBA_ROLE_PRIVS provides information on all the roles granted to users and roles.

  • ROLE_ROLE_PRIVS provides information on all the system roles granted to roles.

  • DBA_SYS_PRIVS provides information on all the system privileges that have been granted to users and roles.

  • ROLE_SYS_PRIVS provides information on all the system privileges that have been granted to roles.

  • ROLE_TAB_PRIVS provides information on all the system object privileges that have been granted to roles.

  • SESSION_ROLES provides information on all the roles that the currently logged-in ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial