9 Oracle Database Real Application Security Data Dictionary Views

Table 9-1 summarizes these views. For additional data dictionary views related to Oracle Real Application Security, see Oracle Database Reference.

Table 9-1 Oracle Database Real Application Security Data Dictionary Views

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 Database Reference for more information. For information about unified auditing in an Oracle Database Real Application Security environment, see Oracle Database Security Guide.
`DBA_XS_AUDIT_TRAIL`	Provides detailed information about Real Application Security that were audited. See Oracle Database Reference for more information. For information about unified auditing in an Oracle Database Real Application Security environment, see Oracle Database Security Guide.
`DBA_XS_ENB_AUDIT_POLICIES`	Lists users for whom Real Application Security unified audit polices are enabled. See Oracle Database Reference for more information. For information about unified auditing in an Oracle Database Real Application Security environment, see Oracle Database Security Guide.

DBA_XS_OBJECTS

The DBA_XS_OBJECTS data dictionary view lists all the existing Real Application Security objects in the database.

Related Views

DBA_XS_PRINCIPALS
DBA_XS_SECURITY_CLASSES
DBA_XS_ACLS
DBA_XS_POLICIES
DBA_XS_NS_TEMPLATES

Column	Datatype	NULL	Description
`NAME`	`VARCHAR2(128)`		Name of the object
`OWNER`	`VARCHAR2(128)`		Owner of the object
`ID`	`NUMBER`	`NOT NULL`	Identifier number for the object
`TYPE`	`VARCHAR2(18)`		Type of the object. Possible values are: `PRINCIPAL` (Application User/Application Role) `SECURITY CLASS` `ACL` `PRIVILEGE` `DATA SECURITY` (Policy) `NAMESPACE TEMPLATE`
`STATUS`	`VARCHAR2(8)`		Status of the object. Possible values are: `INVALID` `VALID` `EXTERNAL`

DBA_XS_PRINCIPALS

The DBA_XS_PRINCIPALS data dictionary view describes all the existing application users and application roles in the database.

Related Views

DBA_XS_USERS
DBA_XS_ROLES
DBA_XS_DYNAMIC_ROLES
DBA_XS_PROXY_ROLES
DBA_XS_EXTERNAL_PRINCIPALS

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the principal (application user or application role)
`GUID`	`RAW(16)`	Globally unique identifier for the principal
`TYPE`	`VARCHAR2(12)`	Type of the principal. Possible values are: USER ROLE DYNAMIC ROLE
`EXTERNAL_SOURCE`	`VARCHAR2(128)`	External source of the principal
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the principal

DBA_XS_EXTERNAL_PRINCIPALS

The DBA_XS_EXTERNAL_PRINCIPALS data dictionary view lists all the external application users and application roles.

Related Views

DBA_XS_PRINCIPALS
DBA_XS_USERS
DBA_XS_ROLES
DBA_XS_DYNAMIC_ROLES
DBA_XS_PROXY_ROLES

Column	Datatype	NULL	Description
`NAME`	`VARCHAR2(128)`		Name of the external principal

DBA_XS_USERS

The DBA_XS_USERS data dictionary view describes all existing application users defined in the database.

Related Views

DBA_XS_PRINCIPALS
USER_XS_USERS
DBA_XS_ROLES
DBA_XS_DYNAMIC_ROLES
DBA_XS_PROXY_ROLES

Column	Datatype	NULL	Description
`NAME`	`VARCHAR2(128)`		Name of the application user
`GUID`	`RAW(16)`		Globally unique identifier for the application user
`EXTERNAL_SOURCE`	`VARCHAR2(128)`		External Source of application users, such as LDAP
`ROLES_DEFAULT_ENABLED`	`VARCHAR2(3)`		Indicates whether all the application roles granted to the application user are enabled by default. Valid values are `YES` and `NO`.
`STATUS`	`VARCHAR2(8)`		Status of the application user. Valid values are `ACTIVE` and `INACTIVE`.
`ACCOUNT_STATUS`	`VARCHAR2(32)`	`NOT NULL`	Direct login password policy account status of the user. Indicates whether the account is locked, expired, or unlocked.
`LOCK_DATE`	`DATE`		The date the account became locked for the direct login user
`EXPIRY_DATE`	`DATE`		The date the passward became expired for the direct login user
`PROFILE`	`VARCHAR2(128)`		The name of the database profile associated with the application user
`SCHEMA`	`VARCHAR2(128)`		Application user schema
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Effective start date for the user
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Effective end date for the user
`DIRECT_LOGON_USER`	`VARCHAR2(3)`		Indicates whether this user has direct logon capability
`VERIFIER_TYPE`	`VARCHAR2(11)`		Type of the verifier assigned to the direct logon user. Only XS_`SHA512` and `XS_SALTED`_`SHA1` are allowed.)
`DESCRIPTION`	`VARCHAR2(4000)`		Description of the application user

USER_XS_USERS

The USER_XS_USERS data dictionary view describes the current application users own account information.

Related Views

DBA_XS_USERS
DBA_XS_PRINCIPALS
DBA_XS_ROLES
DBA_XS_DYNAMIC_ROLES
DBA_XS_PROXY_ROLES

Column	Datatype	NULL	Description
`NAME`	`VARCHAR2(128)`		Name of the current application user
`STATUS`	`VARCHAR2(8)`		Status of the current application user. Valid values are `ACTIVE` and `INACTIVE` only.
`ACCOUNT_STATUS`	`VARCHAR2(32)`	`NOT NULL`	Direct login password policy account status of the current user. Valid values are `UNLOCK`, `LOCKED`, and `EXPIRED`. `UNLOCK` means the current user's account is open.
`LOCK_DATE`	`DATE`		The date the account became locked for the direct login session for the current user
`EXPIRY_DATE`	`DATE`		The date the passward became expired or the direct login session for the current user
`DIRECT_LOGON_USER`	`VARCHAR2(3)`		Indicates whether this user has direct logon capability
`DESCRIPTION`	`VARCHAR2(4000)`		Description of the application user

USER_XS_PASSWORD_LIMITS

The USER_XS_PASSWORD_LIMITS data dictionary view describes the password limits for the currently logged on application user. The DBA can query this view to check the limits for any direct login user.

Related Views

Column	Datatype	NULL	Description
`RESOURCE_NAME`	`VARCHAR2(32)`	`NOT NULL`	Name of the password resource
`LIMIT`	`VARCHAR2(128)`		The limit placed on this resource

DBA_XS_ROLES

The DBA_XS_ROLES data dictionary view describes all existing application roles in the database.

Related Views

DBA_XS_PRINCIPALS
DBA_XS_USERS
DBA_XS_DYNAMIC_ROLES
DBA_XS_PROXY_ROLES
DBA_XS_ROLE_GRANTS

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the application role
`GUID`	`RAW(16)`	Globally unique identifier for the application role
`EXTERNAL_SOURCE`	`VARCHAR2(128)`	External Source of the application role, such as LDAP
`DEFAULT_ENABLED`	`VARCHAR(3)`	Whether or not the application role is enabled by default. Values can be YES or NO.
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	Start date from which the application role is valid
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	End date until which the application role is valid
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the application role

DBA_XS_DYNAMIC_ROLES

The DBA_XS_DYNAMIC_ROLES data dictionary view describes all existing dynamic application roles in the database.

Related Views

DBA_XS_PRINCIPALS
DBA_XS_USERS
DBA_XS_ROLES
DBA_XS_ROLE_GRANTS

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the dynamic application role
`GUID`	`RAW(16)`	Globally unique identifier for the dynamic application role
`DURATION`	`NUMBER`	Duration (in minutes) for which the role has been active
`SYSTEM_DEFINED`	`VARCHAR2(3)`	Indicates whether the application role is a system-defined role. Possible values are `YES` and `NO`.
`SCOPE`	`VARCHAR2(7)`	Scope of the application role. Possible values are `SESSION` and `REQUEST`.
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the dynamic application role.

DBA_XS_PROXY_ROLES

The DBA_XS_PROXY_ROLES data dictionary view describes all Real Application Security proxy application role grants.

Related Views

DBA_XS_PRINCIPALS
DBA_XS_USERS
DBA_XS_ROLES
DBA_XS_DYNAMIC_ROLES
DBA_XS_ROLE_GRANTS

Column	Datatype	Description
`PROXY_USER`	`VARCHAR2(128)`	Name of the proxy application user
`TARGET_USER`	`VARCHAR2(128)`	Name of the target application user
`TARGET_ROLE`	`VARCHAR2(128)`	Name of the target application role

DBA_XS_ROLE_GRANTS

The DBA_XS_ROLE_GRANTS data dictionary view describes all Real Application Security application role grants.

Related Views

DBA_XS_PRINCIPALS
DBA_XS_USERS
DBA_XS_ROLES
DBA_XS_DYNAMIC_ROLES
DBA_XS_PROXY_ROLES

Column	Datatype	Description
`GRANTEE`	`VARCHAR2(128)`	Name of the principal to which the application role is granted
`GRANTED_ROLE`	`VARCHAR2(128)`	Name of the granted application role
`GRANTED_ROLE_TYPE`	`VARCHAR2(11)`	Name of the granted role
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	Start date from which the application role grant is valid
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	End date until which the application role grant is valid

DBA_XS_PRIVILEGES

The DBA_XS_PRIVILEGES data dictionary view lists all the Real Application Security application privileges defined in the database.

Related Views

USER_XS_PRIVILEGES
DBA_XS_IMPLIED_PRIVILEGES
USER_XS_IMPLIED_PRIVILEGES
DBA_XS_SECURITY_CLASSES

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the application privilege
`SECURITY_CLASS`	`VARCHAR2(128`)	Name of the security class that contains the application privilege
`SECURITY_CLASS_OWNER`	`VARCHAR2(128)`	Owner of the security class that contains the application privilege
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the application privilege.

USER_XS_PRIVILEGES

The USER_XS_PRIVILEGES data dictionary view lists the application privileges contained in security classes owned by the current user.

Related Views

DBA_XS_PRIVILEGES
DBA_XS_IMPLIED_PRIVILEGES
USER_XS_IMPLIED_PRIVILEGES
USER_XS_SECURITY_CLASSES

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the application privilege
`SECURITY_CLASS`	`VARCHAR2(128`)	Name of the security class that contains the application privilege
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the application privilege.

DBA_XS_IMPLIED_PRIVILEGES

The DBA_XS_IMPLIED_PRIVILEGES data dictionary view lists all the Real Application Security implied application privileges defined in the database.

Related Views

DBA_XS_PRIVILEGES
USER_XS_PRIVILEGES
USER_XS_IMPLIED_PRIVILEGES
DBA_XS_SECURITY_CLASSES

Column	Datatype	Description
`PRIVILEGE`	`VARCHAR2(128)`	Name of the application privilege containing the implied application privilege
`IMPLIED_PRIVILEGE`	`VARCHAR2(128)`	Name of the implied application privilege
`SECURITY_CLASS`	`VARCHAR2(128`)	Name of the security class that contains the application privilege
`SECURITY_CLASS_OWNER`	`VARCHAR2(128)`	Owner of the security class that contains the application privilege

USER_XS_IMPLIED_PRIVILEGES

The USER_XS_IMPLIED_PRIVILEGES data dictionary view lists the implied application privileges contained in security classes owned by the current user.

Related Views

DBA_XS_PRIVILEGES
USER_XS_PRIVILEGES
DBA_XS_IMPLIED_PRIVILEGES
USER_XS_SECURITY_CLASSES

Column	Datatype	Description
`PRIVILEGE`	`VARCHAR2(128)`	Name of the application privilege containing the implied application privilege
`IMPLIED_PRIVILEGE`	`VARCHAR2(128)`	Name of the implied application privilege
`SECURITY_CLASS`	`VARCHAR2(128`)	Name of the security class that contains the application privilege

DBA_XS_SECURITY_CLASSES

The DBA_XS_SECURITY_CLASSES data dictionary view lists all Real Application Security security classes defined in the database.

Related Views

USER_XS_SECURITY_CLASSES
DBA_XS_SECURITY_CLASS_DEP
USER_XS_SECURITY_CLASS_DEP

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the security class.
`OWNER`	`VARCHAR2(128)`	Owner of the security class.
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the security class.

USER_XS_SECURITY_CLASSES

The USER_XS_SECURITY_CLASSES data dictionary view lists all Real Application Security security classes owned by the current user.

Related Views

DBA_XS_SECURITY_CLASSES
DBA_XS_SECURITY_CLASS_DEP
USER_XS_SECURITY_CLASS_DEP

Column	Datatype	NULL	Description
`NAME`	`VARCHAR2(128)`		Name of the security class.
`DESCRIPTION`	`VARCHAR2(4000)`		Description of the security class.

DBA_XS_SECURITY_CLASS_DEP

The DBA_XS_SECURITY_CLASS_DEP data dictionary view lists the dependencies between all security classes defined in the database.

Related Views

USER_XS_SECURITY_CLASS_DEP
DBA_XS_SECURITY_CLASSES
USER_XS_SECURITY_CLASSES

Column	Datatype	Description
`SECURITY_CLASS`	`VARCHAR2(128`)	Name of the security class
`OWNER`	`VARCHAR2(128)`	Owner of the security class
`PARENT`	`VARCHAR2(128)`	Name of the parent security class
`PARENT_OWNER`	`VARCHAR2(128)`	Owner of the parent security class

USER_XS_SECURITY_CLASS_DEP

The USER_XS_SECURITY_CLASS_DEP data dictionary view lists the parent security classes for the dependent security classes owned by the current user.

Related Views

DBA_XS_SECURITY_CLASS_DEP
DBA_XS_SECURITY_CLASSES
USER_XS_SECURITY_CLASSES

Column	Datatype	Description
`SECURITY_CLASS`	`VARCHAR2(128`)	Name of the security class
`PARENT`	`VARCHAR2(128)`	Name of the parent security class
`PARENT_OWNER`	`VARCHAR2(128)`	Owner of the parent security class

DBA_XS_ACLS

The DBA_XS_ACLS data dictionary view lists all the existing Real Application Security ACLs defined in the database.

Related Views

USER_XS_ACLS
DBA_XS_ACES

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the ACL.
`OWNER`	`VARCHAR2(128)`	Owner of the ACL.
`SECURITY_CLASS`	`VARCHAR2(128)`	Name of the security class associated with the ACL
`SECURITY_CLASS_OWNER`	`VARCHAR2(128)`	Owner of the security class associated with the ACL.
`PARENT_ACL`	`VARCHAR2(128)`	Name of the parent ACL.
`PARENT_ACL_OWNER`	`VARCHAR2(128)`	Owner of the parent ACL
`INHERITANCE_TYPE`	`VARCHAR2(11)`	Inheritance type of the ACL (`EXTENDED` or `CONSTRAINED`)
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the ACL

USER_XS_ACLS

The USER_XS_ACLS data dictionary view lists all the ACLs owned by the current user.

Related Views

DBA_XS_ACLS
USER_XS_ACES

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the ACL.
`SECURITY_CLASS`	`VARCHAR2(128)`	Name of the security class associated with the ACL
`SECURITY_CLASS_OWNER`	`VARCHAR2(128)`	Owner of the security class associated with the ACL.
`PARENT_ACL`	`VARCHAR2(128)`	Name of the parent ACL.
`PARENT_ACL_OWNER`	`VARCHAR2(128)`	Owner of the parent ACL
`INHERITANCE_TYPE`	`VARCHAR2(11)`	Inheritance type of the ACL (`EXTENDED` or `CONSTRAINED`)
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the ACL

DBA_XS_ACES

The DBA_XS_ACES data dictionary view lists all the Access Control Entries (ACEs) defined in the database.

Related Views

USER_XS_ACES
DBA_XS_ACLS

Column	Datatype	NULL	Description
`ACL`	`VARCHAR2(128)`		Name of the ACL
`OWNER`	`VARCHAR2(128)`		Owner of the ACL
`ACE_ORDER`	`NUMBER`	`NOT NULL`	Order number of the ACE in the ACL
`START_DATE`	`TIMESTAMP(6)`		Effective start date of the ACE
`END_DATE`	`TIMESTAMP(6)`		Effective end date of the ACE
`GRANT_TYPE`	`VARCHAR2(5)`		Specifies whether the ACE is a `GRANT` or `DENY`
`INVERTED_PRINCIPAL`	`VARCHAR2(3)`		`YES` if the principal is inverted, else `NO`
`PRINCIPAL`	`VARCHAR2(128)`		Name of the principal to whom the ACE applies
`PRINCIPAL_TYPE`	`VARCHAR2(16)`		Type of the principal, such as application user or application role
`PRIVILEGE`	`VARCHAR2(128)`		Name of the application privilege
`SECURITY_CLASS`	`VARCHAR2(128)`		Name of the security class that scopes the ACL
`SECURITY_CLASS_OWNER`	`VARCHAR2(128)`		Owner of the security class that scopes the ACL

USER_XS_ACES

The USER_XS_ACES data dictionary view lists all the Access Control Entries (ACEs) from the ACLs owned by the current user.

Related Views

DBA_XS_ACES
USER_XS_ACLS

Column	Datatype	NULL	Description
`ACL`	`VARCHAR2(128)`		Name of the ACL
`ACE_ORDER`	`NUMBER`	`NOT NULL`	Order number of the ACE in the ACL
`START_DATE`	`TIMESTAMP(6)`		Effective start date of the ACE
`END_DATE`	`TIMESTAMP(6)`		Effective end date of the ACE
`GRANT_TYPE`	`VARCHAR2(5)`		Specifies whether the ACE is a `GRANT` or `DENY`
`INVERTED_PRINCIPAL`	`VARCHAR2(3)`		`YES` if the principal is inverted, else `NO`
`PRINCIPAL`	`VARCHAR2(128)`		Name of the principal to whom the ACE applies
`PRINCIPAL_TYPE`	`VARCHAR2(16)`		Type of the principal, such as application user or application role
`PRIVILEGE`	`VARCHAR2(128)`		Name of the application privilege
`SECURITY_CLASS`	`VARCHAR2(128)`		Name of the security class that scopes the ACL
`SECURITY_CLASS_OWNER`	`VARCHAR2(128)`		Owner of the security class that scopes the ACL

DBA_XS_POLICIES

The DBA_XS_POLICIES data dictionary view lists all the existing Real Application Security data security policies defined in the database.

Related Views

USER_XS_POLICIES
DBA_XS_REALM_CONSTRAINTS
DBA_XS_COLUMN_CONSTRAINTS

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the data security policy
`OWNER`	`VARCHAR2(128)`	Owner of the data security policy
`CREATE_TIME`	`TIMESTAMP(6)`	When was the policy created
`MODIFY_TIME`	`TIMESTAMP(6)`	When was the policy last modified
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the data security policy

USER_XS_POLICIES

The USER_XS_POLICIES data dictionary view lists all the existing Real Application Security data security policies owned by the current user.

Related Views

DBA_XS_POLICIES
USER_XS_REALM_CONSTRAINTS
USER_XS_COLUMN_CONSTRAINTS

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the data security policy
`CREATE_TIME`	`TIMESTAMP(6)`	When was the policy created
`MODIFY_TIME`	`TIMESTAMP(6)`	When was the policy last modified
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the data security policy

DBA_XS_REALM_CONSTRAINTS

The DBA_XS_REALM_CONSTRAINTS data dictionary view displays all existing Real Application Security realms in the database.

Related Views

USER_XS_REALM_CONSTRAINTS
DBA_XS_COLUMN_CONSTRAINTS

Column	Datatype	NULL	Description
`POLICY`	`VARCHAR2(128`)		Name of the data security policy
`POLICY_OWNER`	`VARCHAR2(128)`		Owner of the data security policy
`REALM_ORDER`	`NUMBER`	`NOT NULL`	The order of the realm within the data security policy
`REALM_TYPE`	`VARCHAR2(13)`		The type of the realm. Valid values are `REGULAR`, `PARAMETERIZED`, and `INHERITED.`
`STATIC`	`VARCHAR2(7)`		Indicates whether the realm is `STATIC` or `DYNAMIC`
`REALM`	`VARCHAR2(4000)`		The data realm.
`ACL`	`VARCHAR2(128)`		ACL associated with the realm if the realm type is `REGULAR`
`ACL_OWNER`	`VARCHAR2(128)`		Owner of the ACL associated with the `REGULAR` realm
`PARENT_OBJECT`	`VARCHAR2(128)`		Name of the parent object if the realm type is `INHERITED`
`PARENT_SCHEMA`	`VARCHAR2(128)`		Schema of the parent object if the realm type is `INHERITED`

USER_XS_REALM_CONSTRAINTS

The USER_XS_REALM_CONSTRAINTS data dictionary view displays all existing Real Application Security realms owned by the current user.

Related Views

DBA_XS_REALM_CONSTRAINTS
USER_XS_COLUMN_CONSTRAINTS

Column	Datatype	NULL	Description
`POLICY`	`VARCHAR2(128`)		Name of the data security policy
`REALM_ORDER`	`NUMBER`	`NOT NULL`	The order of the realm within the data security policy
`REALM_TYPE`	`VARCHAR2(13)`		The type of the realm. Valid values are `REGULAR`, `PARAMETERIZED`, and `INHERITED.`
`STATIC`	`VARCHAR2(7)`		Indicates whether the realm is `STATIC` or `DYNAMIC`
`REALM`	`VARCHAR2(4000)`		The data realm.
`ACL`	`VARCHAR2(128)`		ACL associated with the realm if the realm type is `REGULAR`
`ACL_OWNER`	`VARCHAR2(128)`		Owner of the ACL associated with the `REGULAR` realm
`PARENT_OBJECT`	`VARCHAR2(128)`		Name of the parent object if the realm type is `INHERITED`
`PARENT_SCHEMA`	`VARCHAR2(128)`		Schema of the parent object if the realm type is `INHERITED`

DBA_XS_INHERITED_REALMS

The DBA_XS_INHERITED_REALMS data dictionary view displays all the inherited Real Application Security realms in the database.

Related Views

USER_XS_INHERITED_REALMS
DBA_XS_REALM_CONSTRAINTS

Column	Datatype	NULL	Description
`POLICY`	`VARCHAR2(128`)		Name of the data security policy
`POLICY_OWNER`	`VARCHAR2(128)`		Owner of the data security policy
`REALM_ORDER`	`NUMBER`	`NOT NULL`	The order of the realm within the data security policy
`PARENT_OBJECT`	`VARCHAR2(128)`		Name of the parent object
`PARENT_SCHEMA`	`VARCHAR2(128)`		Schema of the parent object
`PRIMARY_KEY`	`VARCHAR2(128)`		The column name in the master table
`FOREIGN_KEY`	`VARCHAR2(4000)`		The column name or value in the detail table
`FOREIGN_KEY_TYPE`	`VARCHAR2(5)`		Type of the foreign key. Possible values are `NAME` and `VALUE.`

USER_XS_INHERITED_REALMS

The USER_XS_INHERITED_REALMS data dictionary view displays all the inherited Real Application Security realms owned by the current user.

Related Views

DBA_XS_INHERITED_REALMS
USER_XS_REALM_CONSTRAINTS

Column	Datatype	NULL	Description
`POLICY`	`VARCHAR2(128`)		Name of the data security policy
`REALM_ORDER`	`NUMBER`	`NOT NULL`	The order of the realm within the data security policy
`PARENT_OBJECT`	`VARCHAR2(128)`		Name of the parent object
`PARENT_SCHEMA`	`VARCHAR2(128)`		Schema of the parent object
`PRIMARY_KEY`	`VARCHAR2(128)`		The column name in the master table
`FOREIGN_KEY`	`VARCHAR2(4000)`		The column name or value in the detail table
`FOREIGN_KEY_TYPE`	`VARCHAR2(5)`		Type of the foreign key. Possible values are `NAME` and `VALUE.`

DBA_XS_ACL_PARAMETERS

The DBA_XS_ACL_PARAMETERS data dictionary view displays all existing Real Application Security ACL parameters.

Related Views

USER_XS_ACL_PARAMETERS
DBA_XS_REALM_CONSTRAINTS

Column	Datatype	Description
`POLICY`	`VARCHAR2(128`)	Name of the data security policy where the ACL parameter is defined
`POLICY_OWNER`	`VARCHAR2(128)`	Owner of the data security policy where the ACL parameter is defined
`ACL`	`VARCHAR2(128)`	Name of the ACL
`ACL_OWNER`	`VARCHAR2(128)`	Owner of the ACL
`PARAMETER`	`VARCHAR2(128)`	Name of the ACL parameter
`DATATYPE`	`VARCHAR2(9)`	Data type of the ACL parameter
`VALUE`	`VARCHAR2(4000)`	Value of the ACL parameter
`REALM_ORDER`	`NUMBER`	The order of the realm within the data security policy
`REALM`	`VARCHAR2(4000)`	The realm that contains the ACL parameter

USER_XS_ACL_PARAMETERS

The USER_XS_ACL_PARAMETERS data dictionary view displays all ACL parameters defined in the data security policies owned by the current user.

Related Views

DBA_XS_ACL_PARAMETERS
USER_XS_REALM_CONSTRAINTS

Column	Datatype	Description
`POLICY`	`VARCHAR2(128`)	Name of the data security policy where the ACL parameter is defined
`ACL`	`VARCHAR2(128)`	Name of the ACL
`ACL_OWNER`	`VARCHAR2(128)`	Owner of the ACL
`PARAMETER`	`VARCHAR2(128)`	Name of the ACL parameter
`DATATYPE`	`VARCHAR2(9)`	Data type of the ACL parameter
`VALUE`	`VARCHAR2(4000)`	Value of the ACL parameter
`REALM_ORDER`	`NUMBER`	The order of the realm within the data security policy
`REALM`	`VARCHAR2(4000)`	The realm that contains the ACL parameter

DBA_XS_COLUMN_CONSTRAINTS

The DBA_XS_COLUMN_CONSTRAINTS data dictionary view lists all Real Application Security column constraints defined in the database.

Related Views

USER_XS_COLUMN_CONSTRAINTS
DBA_XS_POLICIES

Column	Datatype	NULL	Description
`POLICY`	`VARCHAR2(128)`	NA	Name of the data security policy containing the column constraint
`OWNER`	`VARCHAR2(128)`	NA	Owner of the data security policy containing the column constraint
`COLUMN_NAME`	`VARCHAR2(128)`	NA	Name of the column that has the column constraint applied to it
`PRIVILEGE`	`VARCHAR2(128)`	NA	Name of the application privilege required to access the column

USER_XS_COLUMN_CONSTRAINTS

The USER_XS_COLUMN_CONSTRAINTS data dictionary view lists all Real Application Security column constraints owned by the current user.

Related Views

DBA_XS_COLUMN_CONSTRAINTS
USER_XS_POLICIES

Column	Datatype	Description
`POLICY`	`VARCHAR2(128)`	Name of the data security policy containing the column constraint
`OWNER`	`VARCHAR2(128)`	Owner of the data security policy containing the column constraint
`COLUMN_NAME`	`VARCHAR2(128)`	Name of the column that has the column constraint applied to it
`PRIVILEGE`	`VARCHAR2(128)`	Name of the application privilege required to access the column

DBA_XS_APPLIED_POLICIES

The DBA_XS_APPLIED_POLICIES data dictionary view displays all database objects on which Real Application Security data security policies are enabled.

Related Views

DBA_XS_POLICIES

Column	Datatype	NULL	Description
`SCHEMA`	`VARCHAR2(128`)	`NOT NULL`	Schema containing the object
`OBJECT`	`VARCHAR2(128)`	`NOT NULL`	Name of the data security enabled object in the database
`POLICY`	`VARCHAR2(128)`		Name of the data security policy associated with the object
`POLICY_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the data security policy associated with the object
`SEL`	`VARCHAR2(3`)		Policy enabled for `SELECT` statements
`INS`	`VARCHAR2(3)`		Policy enabled for `INSERT` statements
`UPD`	`VARCHAR2(3)`		Policy enabled for `UPDATE` statements
`DEL`	`VARCHAR2(3)`		Policy enabled for `DELETE` statements
`IDX`	`VARCHAR2(3)`		Policy enabled for `INDEX` statements
`STATUS`	`VARCHAR2(8)`		`ENABLED` if the data security policy is enabled for the object, else `DISABLED`

DBA_XS_MODIFIED_POLICIES

The DBA_XS_MODIFIED_POLICIES data dictionary view displays all database objects on which Real Application Security data security policies are modified.

Related Views

DBA_XS_POLICIES
DBA_XS_APPLIED_POLICIES

Column	Datatype	NULL	Description
`POLICY`	`VARCHAR2(128)`	NOT NULL	Name of the data security policy associated with the object
`OBJECT`	`VARCHAR2(128)`	`NOT NULL`	Name of the data security modified object in the database

DBA_XS_SESSIONS

The DBA_XS_SESSIONS dynamic data dictionary view displays all the application sessions in the database. Only database administrators can select from this view.

Related Views

DBA_XS_ACTIVE_SESSIONS
DBA_XS_SESSION_ROLES
DBA_XS_SESSION_NS_ATTRIBUTES

Column	Datatype	NULL	Description
`USER_NAME`	`VARCHAR2(128`)	`NOT NULL`	Application user name of the application session
`SESSIONID`	`RAW(16)`	`NOT NULL`	Application Session identifier
`PROXY_USER`	`VARCHAR2(128)`		Name of the proxy application user
`COOKIE`	`VARCHAR2(1024)`		The server-unique cookie value associated with the session
`CREATE_TIME`	`TIMESTAMP(6)`	`NOT NULL`	Creation time for the application session
`AUTH_TIME`	`TIMESTAMP(6)`	`NOT NULL`	Last time the application user was authenticated.
`ACCESS_TIME`	`TIMESTAMP(6)`	`NOT NULL`	Last time that the application session was accessed
`INACTIVE_TIMEOUT`	`NUMBER(6)`		The amount of time (in minutes) before the application session is considered timed out

DBA_XS_ACTIVE_SESSIONS

The DBA_XS_ACTIVE_SESSIONS dynamic data dictionary view displays all attached application sessions in the database. Only database administrators can select from this view.

Related Views

DBA_XS_SESSIONS
DBA_XS_SESSION_ROLES
DBA_XS_SESSION_NS_ATTRIBUTES

Column	Datatype	NULL	Description
`USER_NAME`	`VARCHAR2(128`)	`NOT NULL`	Application user name of the application session
`SESSIONID`	`RAW(16)`	`NOT NULL`	Application Session identifier
`DATABASE_SESSIONID`	`NUMBER`		The database session ID to which the application session is associated.
`PROXY_USER`	`VARCHAR2(128)`		Name of the proxy application user
`COOKIE`	`VARCHAR2(1024)`		The server-unique cookie value associated with the session
`CREATE_TIME`	`TIMESTAMP(6)`	`NOT NULL`	Creation time for the application session
`AUTH_TIME`	`TIMESTAMP(6)`	`NOT NULL`	Last time the application user was authenticated.
`ACCESS_TIME`	`TIMESTAMP(6)`	`NOT NULL`	Last time that the application session was accessed
`INACTIVE_TIMEOUT`	`NUMBER(6)`		The amount of time (in minutes) before the application session is considered timed out

DBA_XS_SESSION_ROLES

The DBA_XS_SESSION_ROLES dynamic data dictionary view lists application roles enabled in application sessions.

Related Views

DBA_XS_SESSIONS
DBA_XS_ACTIVE_SESSIONS
DBA_XS_SESSION_NS_ATTRIBUTES

Column	Datatype	NULL	Description
`SESSIONID`	`RAW(16)`	`NOT NULL`	Application session ID
`ROLE`	`VARCHAR2(128)`	`NOT NULL`	Name of the application role

DBA_XS_SESSION_NS_ATTRIBUTES

The DBA_XS_SESSION_NS_ATTRIBUTES data dictionary view displays namespace attributes across application sessions as of last saved state.

Related Views

DBA_XS_SESSIONS
DBA_XS_ACTIVE_SESSIONS
DBA_XS_SESSION_ROLES

Column	Datatype	NULL	Description
`SESSIONID`	`RAW(16)`	`NOT NULL`	Session ID of the application session
`ATTRIBUTE`	`VARCHAR2(4000)`		Name of the attribute
`NAMESPACE`	`VARCHAR2(128)`	`NOT NULL`	Name of the namespace
`VALUE`	`VARCHAR2(4000)`		Value of the attribute
`DEFAULT_VALUE`	`VARCHAR2(4000)`		Default value of the attribute
`FIRSTREAD_EVENT`	`VARCHAR2(2)`		Indicates whether the handler function is invoked when the attribute is first read. Possible values are `YES` and `NO`.
`MODIFY_EVENT`	`VARCHAR2(2)`		Indicates whether the handler function is invoked when the attribute is modified. Possible values are `YES` and `NO`.

DBA_XS_NS_TEMPLATES

The DBA_XS_NS_TEMPLATES data dictionary view describes all Real Application Security namespace templates.

Related Views

DBA_XS_NS_TEMPLATE_ATTRIBUTES

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the namespace template
`HANDLER_SCHEMA`	`VARCHAR2(128)`	Schema of the namespace handler function
`HANDLER_PACKAGE`	`VARCHAR2(128)`	Package containing the namespace handler function
`HANDLER_FUNCTION`	`VARCHAR2(128)`	The namespace handler function
`HANDLER_STATUS`	`VARCHAR2(7)`	Indicates whether the namespace handler function is `VALID` or `INVALID`.
`ACL`	`VARCHAR2(128)`	Name of ACL for the namespace template.
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the namespace template.

DBA_XS_NS_TEMPLATE_ATTRIBUTES

The DBA_XS_NS_TEMPLATE_ATTRIBUTES data dictionary view describes all namespace attributes defined in namespace template documents.

Related Views

DBA_XS_NS_TEMPLATES

Column	Datatype	Description
`ATTRIBUTE`	`VARCHAR2(4000)`	Name of the attribute defined in the namespace template
`NAMESPACE`	`VARCHAR2(128)`	Name of the namespace instantiated by the namespace template
`DEFAULT_VALUE`	`VARCHAR2(4000)`	Default value of the attribute defined in the namespace template
`FIRSTREAD_EVENT`	`VARCHAR2(3)`	Indicates whether the namespace handler function is invoked when the attribute is first read. Valid values are `YES` and `NO`.
`MODIFY_EVENT`	`VARCHAR2(3)`	Indicates whether the namespace handler function is invoked when the attribute value is modified. Valid values are `YES` and `NO`.

ALL_XDS_ACL_REFRESH

The ALL_XDS_ACL_REFRESH data dictionary view displays all static ACL refresh settings for tables that are accessible to the application user.

Related Views

DBA_XDS_ACL_REFRESH
USER_XDS_ACL_REFRESH

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`ACL_MVIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of ACL MV for this table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`ACL_STATUS`	`VARCHAR2(5)`		`STALE` or `FRESH`
`USER_SUPPLIED_MV`	`VARCHAR2(1)`		`Y` or `N`
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job scheduled to run after the timestamp, if scheduled
`REPEAT_INTERVAL`	`VARCHAR2(4000)`		The `repeat_interval` to run the refreshment job, if scheduled
`REFRESH_COUNT`	`NUMBER`		Number of times this ACL MV has been refreshed so far
`COMMENTS`	`VARCHAR2(240)`		Comments for the refreshment

ALL_XDS_ACL_REFSTAT

The ALL_XDS_ACL_REFSTAT data dictionary view displays all static ACL refresh job status history that has been done for tables that are accessible to the application user.

Related Views

DBA_XDS_ACL_REFSTAT
USER_XDS_ACL_REFSTAT

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`JOB_START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job starting time
`JOB_END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job ending time
`ROW_UPDATE_COUNT`	`NUMBER`		Number of rows have been updated for static ACL sync
`STATUS`	`NUMBER`		Refreshment job status: 0 means success, otherwise an error number is displayed.
`ERROR_MESSAGE`	`VARCHAR2(4000)`		The error message for the error, if there is any.

ALL_XDS_LATEST_ACL_REFSTAT

The ALL_XDS_LATEST_ACL_REFSTAT data dictionary view displays all latest static ACL refresh job status history that has been done for tables that are accessible to the application user. It has the same schema as ALL_XDS_ACL_REFSTAT dictionary view, but a subset of its rows.

Related Views

DBA_XDS_LATEST_ACL_REFSTAT
USER_XDS_LATEST_ACL_REFSTAT
ALL_XDS_ACL_REFSTAT

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`JOB_START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job starting time
`JOB_END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job ending time
`ROW_UPDATE_COUNT`	`NUMBER`		Number of rows have been updated for static ACL sync
`STATUS`	`NUMBER`		Refreshment job status: 0 means success, otherwise an error number is displayed.
`ERROR_MESSAGE`	`VARCHAR2(4000)`		The error message for the error, if there is any.

DBA_XDS_ACL_REFRESH

The DBA_XDS_ACL_REFRESH data dictionary view displays all static ACL refresh settings in the database.

Related Views

ALL_XDS_ACL_REFRESH
USER_XDS_ACL_REFRESH

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`ACL_MVIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of ACL MV for this table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`ACL_STATUS`	`VARCHAR2(5)`		`STALE` or `FRESH`
`USER_SUPPLIED_MV`	`VARCHAR2(1)`		`Y` or `N`
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job scheduled to run after the timestamp, if scheduled
`REPEAT_INTERVAL`	`VARCHAR2(4000)`		The `repeat_interval` to run the refreshment job, if scheduled.
`REFRESH_COUNT`	`NUMBER`		Number of refreshment has been done so far
`COMMENTS`	`VARCHAR2(240)`		Comments for the refreshment

DBA_XDS_ACL_REFSTAT

The DBA_XDS_ACL_REFSTAT data dictionary view displays all static ACL refresh job status history that has been done in the database.

Related Views

ALL_XDS_ACL_REFSTAT
USER_XDS_ACL_REFSTAT

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`JOB_START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job starting time
`JOB_END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job ending time
`ROW_UPDATE_COUNT`	`NUMBER`		Number of rows have been updated for static ACL sync
`STATUS`	`NUMBER`		Refreshment job status: 0 means success, otherwise an error number is displayed.
`ERROR_MESSAGE`	`VARCHAR2(4000)`		The error message for the error, if there is any.

DBA_XDS_LATEST_ACL_REFSTAT

The DBA_XDS_LATEST_ACL_REFSTAT data dictionary view displays all latest static ACL refresh job status history that has been done in the database. It has the same schema as DBA_XDS_ACL_REFSTAT dictionary view, but a subset of its rows.

Related Views

ALL_XDS_LATEST_ACL_REFSTAT
USER_XDS_LATEST_ACL_REFSTAT
DBA_XDS_ACL_REFSTAT

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`JOB_START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job starting time
`JOB_END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job ending time
`ROW_UPDATE_COUNT`	`NUMBER`		Number of rows have been updated for static ACL sync
`STATUS`	`NUMBER`		Refreshment job status: 0 means success, otherwise an error number is displayed.
`ERROR_MESSAGE`	`VARCHAR2(4000)`		The error message for the error, if there is any.

USER_XDS_ACL_REFRESH

The USER_XDS_ACL_REFRESH data dictionary view displays all static ACL refresh settings for tables that are owned by the user.

Related Views

ALL_XDS_ACL_REFRESH
DBA_XDS_ACL_REFRESH

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`ACL_MVIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of ACL MV for this table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`ACL_STATUS`	`VARCHAR2(5)`		`STALE` or `FRESH`
`USER_SUPPLIED_MV`	`VARCHAR2(1)`		`Y` or `N`
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job scheduled to run after the timestamp, if scheduled
`REPEAT_INTERVAL`	`VARCHAR2(4000)`		The `repeat_interval` to run the refreshment job, if scheduled.
`REFRESH_COUNT`	`NUMBER`		Number of refreshment has been done so far
`COMMENTS`	`VARCHAR2(240)`		Comments for the refreshment

USER_XDS_ACL_REFSTAT

The USER_XDS_ACL_REFSTAT data dictionary view displays all static ACL refresh job status history that has been done for tables that are owned by the user.

Related Views

ALL_XDS_ACL_REFSTAT
DBA_XDS_ACL_REFSTAT

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`JOB_START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job starting time
`JOB_END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job ending time
`ROW_UPDATE_COUNT`	`NUMBER`		Number of rows have been updated for static ACL sync
`STATUS`	`NUMBER`		Refreshment job status: 0 means success, otherwise an error number is displayed.
`ERROR_MESSAGE`	`VARCHAR2(4000)`		The error message for the error, if there is any.

USER_XDS_LATEST_ACL_REFSTAT

The USER_XDS_LATEST_ACL_REFSTAT data dictionary view displays all latest static ACL refresh job status history that has been done for tables that are owned by the user. It has the same schema as USER_XDS_ACL_REFSTAT dictionary view, but a subset of its rows.

Related Views

ALL_XDS_LATEST_ACL_REFSTAT
DBA_XDS_LATEST_ACL_REFSTAT
USER_XDS_ACL_REFSTAT

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128`)	`NOT NULL`	Name of schema
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of table
`REFRESH_MODE`	`VARCHAR2(9)`		`ON COMMIT`, `SCHEDULED`, or `ON DEMAND`
`REFRESH_ABILITY`	`VARCHAR2(11)`		`COMPLETE` or `INCREMENTAL`
`JOB_START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job starting time
`JOB_END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The refreshment job ending time
`ROW_UPDATE_COUNT`	`NUMBER`		Number of rows have been updated for static ACL sync
`STATUS`	`NUMBER`		Refreshment job status: 0 means success, otherwise an error number is displayed.
`ERROR_MESSAGE`	`VARCHAR2(4000)`		The error message for the error, if there is any.

V$XS_SESSION_NS_ATTRIBUTES

The V$XS_SESSION_NS_ATTRIBUTES dynamic data dictionary view displays information about the namespaces and attributes in all application sessions in the database as of the end of the last request. The state of any active request is not reflected in this view. Only database administrators can select from this view.

Related Views

DBA_XS_SESSIONS
DBA_XS_SESSION_NS_ATTRIBUTES
V$XS_SESSION_ROLES

Column	Datatype	Description
`NAMESPACE_NAME`	`VARCHAR2(4000)`	Name of the namespace
`WORKSPACE_NAME`	`VARCHAR2(129)`	Name of the workspace space for the namespace
`ATTRIBUTE_NAME`	`VARCHAR2(4000)`	Name of the attribute
`ATTRIBUTE_VALUE`	`VARCHAR2(4000)`	Value of the attribute
`ATTRIBUTE_EVENTS`	`VARCHAR2(4000)`	Events associated with this attribute
`ATTRIBUTE_DEFAULT_VALUE`	`VARCHAR2(4000)`	Default value for the attribute
`ATTRIBUTE_TYPE`	VARCHAR2(4000)	Type of attribute, either `TEMPLATE` or `CUSTOM`
`CON_ID`	`NUMBER`	Container ID

V$XS_SESSION_ROLES

The V$XS_SESSION_ROLES static data dictionary view displays all enabled application roles in application session in the current request.

Related Views

DBA_XS_SESSIONS
DBA_XS_SESSION_ROLES
V$XS_SESSION_NS_ATTRIBUTES

Column	Datatype	Description
`ROLE_WSPACE`	`VARCHAR2(129)`	The workspace of the application role.
`ROLE_NAME`	`VARCHAR2(4000`)	Name of enabled application role
`FLAGS`	`NUMBER`	Status flag
`CON_ID`	`NUMBER`	Container ID