Oracle in a Nutshell

Security

The following views provide information about users, grants, and security policies that implement fine-grained access control (FGAC):

*_APPLICATION_ROLES

Describes all application roles that have authentication policy roles defined for them. There is no ALL_ view. New with Oracle9i.

*_COL_PRIVS

Lists all column grants made in the database.

*_GLOBAL_CONTEXT

Lists all the global contexts; these are sets of application-defined attributes that can be used for determining access rights available to the instance. There is no USER_GLOBAL_CONTEXT view. New with Oracle9i.

*_POLICY_CONTEXTS

Lists policies and their associated contexts. New with Oracle9i.

*_POLICY_GROUPS

Lists the various groups for the different security policies. This view is new with Oracle9i.

*_PROFILES

Lists all defined profiles.

RESOURCE_COST

Shows the assigned cost of each resource for composite limits.

RESOURCE_MAP

Maps profile resource numbers to resource names.

*_ROLES

Lists all roles.

*_ROLE_PRIVS

Lists all roles granted to users and to other roles.

ROLE_ROLE_PRIVS

Lists roles granted to other roles. A subset of *_ROLE_PRIVS.

ROLE_SYS_PRIVS

Lists system privileges granted to roles. A subset of *_SYS_PRIVS.

ROLE_TAB_PRIVS

Lists table grants granted to roles. A subset of *_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

*_SYS_PRIVS

Shows which system privileges have been assigned to which users.

*_TAB_PRIVS

Shows ...