Oracle Database Real Application Security Data Dictionary Views

This chapter describes the data dictionary views provided with Oracle Database Real Application Security.

Oracle Database Real Application Security Data Dictionary Views summarizes these views. For additional data dictionary views related to Oracle Real Application Security, see Oracle AI Database Reference.

Data Dictionary View	Summary Description
DBA_XS_OBJECTS	Displays all Real Application Security objects
DBA_XS_PRINCIPALS	Displays all application users and application roles
DBA_XS_EXTERNAL_PRINCIPALS	Displays all external application users and application roles
DBA_XS_USERS	Displays all application users
USER_XS_USERS	Displays the application users own account information
USER_XS_PASSWORD_LIMITS	Displays password limits for the currently logged on application user
DBA_XS_ROLES	Displays all application roles
DBA_XS_DYNAMIC_ROLES	Displays all dynamic application roles
DBA_XS_PROXY_ROLES	Displays all proxy application roles
DBA_XS_ROLE_GRANTS	Displays all Real Application Security application role grants
DBA_XS_PRIVILEGES	Lists all Real Application Security application privileges defined in the database.
USER_XS_PRIVILEGES	Lists application privileges contained in security classes owned by the current user
DBA_XS_IMPLIED_PRIVILEGES	Lists all the Real Application Security implied application privileges defined in the database
USER_XS_IMPLIED_PRIVILEGES	Lists all the implied application privileges contained in security classes owned by the current user
DBA_XS_SECURITY_CLASSES	Lists all security classes defined in the database
USER_XS_SECURITY_CLASSES	Lists all security classes owned by the current application user
DBA_XS_SECURITY_CLASS_DEP	Lists the dependencies between security classes.
USER_XS_SECURITY_CLASS_DEP	Lists the parent security classes for the dependent security classes owned by the current user.
DBA_XS_ACLS	Lists all existing ACLs
USER_XS_ACLS	lists all ACLs owned by the current user
DBA_XS_ACES	Lists all the Access Control Entries (ACEs)
USER_XS_ACES	Lists all the ACEs from the ACLs owned by the current user
DBA_XS_POLICIES	Lists all the data security policies
USER_XS_POLICIES	Lists all the data security policies owned by the current application user
DBA_XS_REALM_CONSTRAINTS	Lists all Real Application Security realms
USER_XS_REALM_CONSTRAINTS	Lists all Real Application Security realms owned by the current user
DBA_XS_INHERITED_REALMS	Lists all Real Application Security inherited realms
USER_XS_INHERITED_REALMS	Lists all Real Application Security inherited realms owned by the current user
DBA_XS_ACL_PARAMETERS	Lists all Real Application Security ACL parameters
USER_XS_ACL_PARAMETERS	Lists all Real Application Security ACL parameters defined in data security policies owned by the current user
DBA_XS_COLUMN_CONSTRAINTS	Lists all Real Application Security column constraints
USER_XS_COLUMN_CONSTRAINTS	Lists all Real Application Security column constraints owned by the current user
DBA_XS_APPLIED_POLICIES	Displays all database objects on which Real Application Security data security policies are enabled
DBA_XS_MODIFIED_POLICIES	Displays all database objects on which Real Application Security data security policies are modified
DBA_XS_SESSIONS	Lists all application sessions in the database
DBA_XS_ACTIVE_SESSIONS	Lists all attached application sessions in the database
DBA_XS_SESSION_ROLES	Lists application roles enabled in application sessions
DBA_XS_SESSION_NS_ATTRIBUTES	Displays namespace attributes across application sessions as of last saved state
DBA_XS_NS_TEMPLATES	Describes all Real Application Security namespace templates
DBA_XS_NS_TEMPLATE_ATTRIBUTES	Describes all namespace templates together with their attribute details
ALL_XDS_ACL_REFRESH	Displays all static ACL refresh settings for tables that are accessible to the application user.
ALL_XDS_ACL_REFSTAT	Displays all static ACL refresh job status history that has been done for tables accessible to the application user.
ALL_XDS_LATEST_ACL_REFSTAT	Displays the ACL refreshjob status for the most recent refreshment job for each table accessible to the application user.
DBA_XDS_ACL_REFRESH	Displays all static ACL refresh settings in the database.
DBA_XDS_ACL_REFSTAT	Displays all static ACL refresh job status history that has been done in the database
DBA_XDS_LATEST_ACL_REFSTAT	Displays the ACL refresh job status for the most recent refreshment job for each table in the database
USER_XDS_ACL_REFRESH	Displays all static ACL refresh settings for tables that are owned by the user.
USER_XDS_ACL_REFSTAT	Displays all static ACL refresh job status history that has been done for tables owned by the user.
USER_XDS_LATEST_ACL_REFSTAT	Displays the ACL refresh job status for the most recent refreshment job for each table owned by the user.
V$XS_SESSION_NS_ATTRIBUTES	Displays information about the namespaces and attributes in the current application session.
V$XS_SESSION_ROLES	Displays all enabled application roles in the current application session.
`DBA_XS_AUDIT_POLICY_OPTIONS`	Describes the auditing options that were defined for Real Application Security unified audit policies. See Oracle AI Database Reference for more information. For information about unified auditing in an Oracle Database Real Application Security environment, see Oracle AI Database Security Guide.
`DBA_XS_AUDIT_TRAIL`	Provides detailed information about Real Application Security that were audited. See Oracle AI Database Reference for more information. For information about unified auditing in an Oracle Database Real Application Security environment, see Oracle AI Database Security Guide.
`DBA_XS_ENB_AUDIT_POLICIES`	Lists users for whom Real Application Security unified audit polices are enabled. See Oracle AI Database Reference for more information. For information about unified auditing in an Oracle Database Real Application Security environment, see Oracle AI Database Security Guide.

This section describes the following Oracle Database Real Application Security data dictionary views: