These views provide information about users and grants. Please refer to Chapter 6, for more details on security.
Lists all column grants made in the database.
Lists all defined profiles.
Lists all roles granted to users and to other roles.
Lists all roles.
Shows which system privileges have been assigned to which users.
Shows all object privileges. Includes not only tables but also views, sequences, packages, procedures, and functions.
Lists all users.
Shows the assigned cost of each resource for composite limits.
Maps profile resource numbers to resource names.
Lists roles granted to other roles. A subset of DBA_ROLE_PRIVS.
Lists system privileges granted to roles. A subset of DBA_SYS_PRIVS.
Lists table grants granted to roles. A subset of DBA_TAB_PRIVS.
Shows which system privileges are active for the current session.
Shows which roles are active for the current session
Shows the password limits in effect for the current session. There is no corresponding DBA_PASSWORD_LIMITS.