Oracle Database Administration: The Essential Refe

Security

These views provide information about users and grants. Please refer to Chapter 6, for more details on security.

DBA_COL_PRIVS

Lists all column grants made in the database.

DBA_PROFILES

Lists all defined profiles.

DBA_ROLE_PRIVS

Lists all roles granted to users and to other roles.

DBA_ROLES

Lists all roles.

DBA_SYS_PRIVS

Shows which system privileges have been assigned to which users.

DBA_TAB_PRIVS

Shows all object privileges. Includes not only tables but also views, sequences, packages, procedures, and functions.

DBA_USERS

Lists all users.

RESOURCE_COST

Shows the assigned cost of each resource for composite limits.

RESOURCE_MAP

Maps profile resource numbers to resource names.

ROLE_ROLE_PRIVS

Lists roles granted to other roles. A subset of DBA_ROLE_PRIVS.

ROLE_SYS_PRIVS

Lists system privileges granted to roles. A subset of DBA_SYS_PRIVS.

ROLE_TAB_PRIVS

Lists table grants granted to roles. A subset of DBA_TAB_PRIVS.

SESSION_PRIVS

Shows which system privileges are active for the current session.

SESSION_ROLES

Shows which roles are active for the current session

USER_PASSWORD_LIMITS

Shows the password limits in effect for the current session. There is no corresponding DBA_PASSWORD_LIMITS.