9 Oracle Database Real Application Security Data Dictionary Views
This chapter describes the data dictionary views provided with Oracle Database Real Application Security.
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 |
|---|---|
|
Displays all Real Application Security objects |
|
|
Displays all application users and application roles |
|
|
Displays all external application users and application roles |
|
|
Displays all application users |
|
|
Displays the application users own account information |
|
|
Displays password limits for the currently logged on application user |
|
|
Displays all application roles |
|
|
Displays all dynamic application roles |
|
|
Displays all proxy application roles |
|
|
Displays all Real Application Security application role grants |
|
|
Lists all Real Application Security application privileges defined in the database. |
|
|
Lists application privileges contained in security classes owned by the current user |
|
|
Lists all the Real Application Security implied application privileges defined in the database |
|
|
Lists all the implied application privileges contained in security classes owned by the current user |
|
|
Lists all security classes defined in the database |
|
|
Lists all security classes owned by the current application user |
|
|
Lists the dependencies between security classes. |
|
|
Lists the parent security classes for the dependent security classes owned by the current user. |
|
|
Lists all existing ACLs |
|
|
lists all ACLs owned by the current user |
|
|
Lists all the Access Control Entries (ACEs) |
|
|
Lists all the ACEs from the ACLs owned by the current user |
|
|
Lists all the data security policies |
|
|
Lists all the data security policies owned by the current application user |
|
|
Lists all Real Application Security realms |
|
|
Lists all Real Application Security realms owned by the current user |
|
|
Lists all Real Application Security inherited realms |
|
|
Lists all Real Application Security inherited realms owned by the current user |
|
|
Lists all Real Application Security ACL parameters |
|
|
Lists all Real Application Security ACL parameters defined in data security policies owned by the current user |
|
|
Lists all Real Application Security column constraints |
|
|
Lists all Real Application Security column constraints owned by the current user |
|
|
Displays all database objects on which Real Application Security data security policies are enabled |
|
|
Displays all database objects on which Real Application Security data security policies are modified |
|
|
Lists all application sessions in the database |
|
|
Lists all attached application sessions in the database |
|
|
Lists application roles enabled in application sessions |
|
|
Displays namespace attributes across application sessions as of last saved state |
|
|
Describes all Real Application Security namespace templates |
|
|
Describes all namespace templates together with their attribute details |
|
|
Displays all static ACL refresh settings for tables that are accessible to the application user. |
|
|
Displays all static ACL refresh job status history that has been done for tables accessible to the application user. |
|
|
Displays the ACL refreshjob status for the most recent refreshment job for each table accessible to the application user. |
|
|
Displays all static ACL refresh settings in the database. |
|
|
Displays all static ACL refresh job status history that has been done in the database |
|
|
Displays the ACL refresh job status for the most recent refreshment job for each table in the database |
|
|
Displays all static ACL refresh settings for tables that are owned by the user. |
|
|
Displays all static ACL refresh job status history that has been done for tables owned by the user. |
|
|
Displays the ACL refresh job status for the most recent refreshment job for each table owned by the user. |
|
|
Displays information about the namespaces and attributes in the current application session. |
|
|
Displays all enabled application roles in the current application session. |
|
|
|
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. |
|
|
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. |
|
|
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. |
This section describes the following Oracle Database Real Application Security data dictionary views:
DBA_XS_OBJECTS
The DBA_XS_OBJECTS data dictionary view lists all the existing Real Application Security objects in the database.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the object |
|
|
|
|
Owner of the object |
|
|
|
|
|
Identifier number for the object |
|
|
|
Type of the object. Possible values are:
|
|
|
|
|
Status of the object. Possible values are:
|
DBA_XS_PRINCIPALS
The DBA_XS_PRINCIPALS data dictionary view describes all the existing application users and application roles in the database.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the principal (application user or application role) |
|
|
|
|
Globally unique identifier for the principal |
|
|
|
|
Type of the principal. Possible values are:
|
|
|
|
|
External source of the principal |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application user |
|
|
|
|
Globally unique identifier for the application user |
|
|
|
|
External Source of application users, such as LDAP |
|
|
|
|
Indicates whether all the application roles granted to the application user are enabled by default. Valid values are |
|
|
|
|
Status of the application user. Valid values are |
|
|
|
|
|
Direct login password policy account status of the user. Indicates whether the account is locked, expired, or unlocked. |
|
|
|
The date the account became locked for the direct login user |
|
|
|
|
The date the passward became expired for the direct login user |
|
|
|
|
The name of the database profile associated with the application user |
|
|
|
|
Application user schema |
|
|
|
|
Effective start date for the user |
|
|
|
|
Effective end date for the user |
|
|
|
|
Indicates whether this user has direct logon capability |
|
|
|
|
Type of the verifier assigned to the direct logon user. Only XS_ |
|
|
|
|
The Real Application Security session privilege. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the current application user |
|
|
|
|
Status of the current application user. Valid values are |
|
|
|
|
|
Direct login password policy account status of the current user. Valid values are |
|
|
|
The date the account became locked for the direct login session for the current user |
|
|
|
|
The date the passward became expired or the direct login session for the current user |
|
|
|
|
Indicates whether this user has direct logon capability |
|
|
|
|
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 |
|---|---|---|---|
|
|
|
|
Name of the password resource |
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application role |
|
|
|
|
Globally unique identifier for the application role |
|
|
|
|
External Source of the application role, such as LDAP |
|
|
|
|
Whether or not the application role is enabled by default. Values can be YES or NO. |
|
|
|
|
Start date from which the application role is valid |
|
|
|
|
End date until which the application role is valid |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the dynamic application role |
|
|
|
|
Globally unique identifier for the dynamic application role |
|
|
|
|
Duration (in minutes) for which the role has been active |
|
|
|
|
Indicates whether the application role is a system-defined role. Possible values are |
|
|
|
|
Scope of the application role. Possible values are |
|
|
|
|
The Real Application Security session privilege. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the proxy application user |
|
|
|
|
Name of the target application user |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the principal to which the application role is granted |
|
|
|
|
Name of the granted application role |
|
|
|
|
Name of the granted role |
|
|
|
|
Start date from which the application role grant is valid |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application privilege |
|
|
|
|
Name of the security class that contains the application privilege |
|
|
|
|
Owner of the security class that contains the application privilege |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application privilege |
|
|
|
|
Name of the security class that contains the application privilege |
|
|
|
|
Description of the application privilege. |
ALL_XS_PRIVILEGES
The ALL_XS_PRIVILEGES data dictionary view lists all the Real Application Security application privileges scoped by the security classes accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application privilege |
|
|
|
|
Name of the security class that contains the application privilege |
|
|
|
|
Owner of the security class that contains the application privilege |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application privilege containing the implied application privilege |
|
|
|
|
Name of the implied application privilege |
|
|
|
|
Name of the security class that contains the application privilege |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application privilege containing the implied application privilege |
|
|
|
|
Name of the implied application privilege |
|
|
|
|
Name of the security class that contains the application privilege |
ALL_XS_IMPLIED_PRIVILEGES
The ALL_XS_IMPLIED_PRIVILEGES data dictionary view lists all the Real Application Security implied application privileges scoped by the security classes accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application privilege containing the implied application privilege |
|
|
|
|
Name of the implied application privilege |
|
|
|
|
Name of the security class that contains the application privilege |
|
|
|
|
Owner of the security class that contains the application privilege |
DBA_XS_PRIVILEGE_GRANTS
The DBA_XS_PRIVILEGE_GRANTS data dictionary view lists all the Real Application Security system or schema level privilege grants defined in the database.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the application privilege |
|
|
|
|
Name of the user to whom access was granted |
|
|
|
|
Type of the grantee: Database or Real Application Security user or role |
|
|
|
|
Schema of the 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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the security class. |
|
|
|
|
Owner of the security class. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the security class. |
|
|
|
|
Description of the security class. |
ALL_XS_SECURITY_CLASSES
The ALL_XS_SECURITY_CLASSES data dictionary view lists all Real Application Security security classes accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the security class. |
|
|
|
|
Owner of the security class. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the security class |
|
|
|
|
Owner of the security class |
|
|
|
|
Name of the parent security class |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the security class |
|
|
|
|
Name of the parent security class |
|
|
|
|
Owner of the parent security class |
ALL_XS_SECURITY_CLASS_DEP
The ALL_XS_SECURITY_CLASS_DEP data dictionary view lists all the RAS security classes that the security classes accessible to the current user are dependent on.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the security class |
|
|
|
|
Owner of the security class |
|
|
|
|
Name of the parent security class |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the ACL. |
|
|
|
|
Owner of the ACL. |
|
|
|
|
Name of the security class associated with the ACL |
|
|
|
|
Owner of the security class associated with the ACL. |
|
|
|
|
Name of the parent ACL. |
|
|
|
|
Owner of the parent ACL |
|
|
|
|
Inheritance type of the ACL ( |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the ACL. |
|
|
|
|
Name of the security class associated with the ACL |
|
|
|
|
Owner of the security class associated with the ACL. |
|
|
|
|
Name of the parent ACL. |
|
|
|
|
Owner of the parent ACL |
|
|
|
|
Inheritance type of the ACL ( |
|
|
|
|
Description of the ACL |
ALL_XS_ACLS
The ALL_XS_ACLS data dictionary view lists all the existing Real Application Security ACLs accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the ACL. |
|
|
|
|
Owner of the ACL. |
|
|
|
|
Name of the security class associated with the ACL |
|
|
|
|
Owner of the security class associated with the ACL. |
|
|
|
|
Name of the parent ACL. |
|
|
|
|
Owner of the parent ACL |
|
|
|
|
Inheritance type of the ACL ( |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the ACL |
|
|
|
|
Owner of the ACL |
|
|
|
|
|
Order number of the ACE in the ACL |
|
|
|
Effective start date of the ACE |
|
|
|
|
Effective end date of the ACE |
|
|
|
|
Specifies whether the ACE is a |
|
|
|
|
|
|
|
|
|
Name of the principal to whom the ACE applies |
|
|
|
|
Type of the principal, such as application user or application role |
|
|
|
|
Name of the application privilege |
|
|
|
|
Name of the security class that scopes the ACL |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the ACL |
|
|
|
|
|
Order number of the ACE in the ACL |
|
|
|
Effective start date of the ACE |
|
|
|
|
Effective end date of the ACE |
|
|
|
|
Specifies whether the ACE is a |
|
|
|
|
|
|
|
|
|
Name of the principal to whom the ACE applies |
|
|
|
|
Type of the principal, such as application user or application role |
|
|
|
|
Name of the application privilege |
|
|
|
|
Name of the security class that scopes the ACL |
|
|
|
|
Owner of the security class that scopes the ACL |
ALL_XS_ACES
The ALL_XS_ACES data dictionary view lists all the Access Control Entries (ACEs) accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the ACL |
|
|
|
|
Owner of the ACL |
|
|
|
|
|
Order number of the ACE in the ACL |
|
|
|
Effective start date of the ACE |
|
|
|
|
Effective end date of the ACE |
|
|
|
|
Specifies whether the ACE is a |
|
|
|
|
|
|
|
|
|
Name of the principal to whom the ACE applies |
|
|
|
|
Type of the principal, such as application user or application role |
|
|
|
|
Name of the application privilege |
|
|
|
|
Name of the security class that scopes the ACL |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
Owner of the data security policy |
|
|
|
|
When was the policy created |
|
|
|
|
When was the policy last modified |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
When was the policy created |
|
|
|
|
When was the policy last modified |
|
|
|
|
Description of the data security policy |
ALL_XS_POLICIES
The ALL_XS_POLICIES data dictionary view lists all the existing Real Application Security data security policies accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
Owner of the data security policy |
|
|
|
|
When was the policy created |
|
|
|
|
When was the policy last modified |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
Owner of the data security policy |
|
|
|
|
|
The order of the realm within the data security policy |
|
|
|
The type of the realm. Valid values are |
|
|
|
|
Indicates whether the realm is |
|
|
|
|
The data realm. |
|
|
|
|
ACL associated with the realm if the realm type is |
|
|
|
|
Owner of the ACL associated with the |
|
|
|
|
Name of the parent object if the realm type is |
|
|
|
|
Schema of the parent object if the realm type is |
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
|
The order of the realm within the data security policy |
|
|
|
The type of the realm. Valid values are |
|
|
|
|
Indicates whether the realm is |
|
|
|
|
The data realm. |
|
|
|
|
ACL associated with the realm if the realm type is |
|
|
|
|
Owner of the ACL associated with the |
|
|
|
|
Name of the parent object if the realm type is |
|
|
|
|
Schema of the parent object if the realm type is |
ALL_XS_REALM_CONSTRAINTS
The ALL_XS_REALM_CONSTRAINTS data dictionary view displays all existing Real Application Security realms accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
Owner of the data security policy |
|
|
|
|
|
The order of the realm within the data security policy |
|
|
|
The type of the realm. Valid values are |
|
|
|
|
Indicates whether the realm is |
|
|
|
|
The data realm. |
|
|
|
|
ACL associated with the realm if the realm type is |
|
|
|
|
Owner of the ACL associated with the |
|
|
|
|
Name of the parent object if the realm type is |
|
|
|
|
Schema of the parent object if the realm type is |
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
Owner of the data security policy |
|
|
|
|
|
The order of the realm within the data security policy |
|
|
|
Name of the parent object |
|
|
|
|
Schema of the parent object |
|
|
|
|
The column name in the master table |
|
|
|
|
The column name or value in the detail table |
|
|
|
|
Type of the foreign key. Possible values are |
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
|
The order of the realm within the data security policy |
|
|
|
Name of the parent object |
|
|
|
|
Schema of the parent object |
|
|
|
|
The column name in the master table |
|
|
|
|
The column name or value in the detail table |
|
|
|
|
Type of the foreign key. Possible values are |
ALL_XS_INHERITED_REALMS
The ALL_XS_INHERITED_REALMS data dictionary view displays all the inherited Real Application Security realms accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy |
|
|
|
|
Owner of the data security policy |
|
|
|
|
|
The order of the realm within the data security policy |
|
|
|
Name of the parent object |
|
|
|
|
Schema of the parent object |
|
|
|
|
The column name in the master table |
|
|
|
|
The column name or value in the detail table |
|
|
|
|
Type of the foreign key. Possible values are |
DBA_XS_ACL_PARAMETERS
The DBA_XS_ACL_PARAMETERS data dictionary view displays all existing Real Application Security ACL parameters.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy where the ACL parameter is defined |
|
|
|
|
Owner of the data security policy where the ACL parameter is defined |
|
|
|
|
Name of the ACL |
|
|
|
|
Owner of the ACL |
|
|
|
|
Name of the ACL parameter |
|
|
|
|
Data type of the ACL parameter |
|
|
|
|
Value of the ACL parameter |
|
|
|
|
The order of the realm within the data security policy |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy where the ACL parameter is defined |
|
|
|
|
Name of the ACL |
|
|
|
|
Owner of the ACL |
|
|
|
|
Name of the ACL parameter |
|
|
|
|
Data type of the ACL parameter |
|
|
|
|
Value of the ACL parameter |
|
|
|
|
The order of the realm within the data security policy |
|
|
|
|
The realm that contains the ACL parameter |
ALL_XS_ACL_PARAMETERS
The ALL_XS_ACL_PARAMETERS data dictionary view displays all existing Real Application Security ACL parameters defined in the data security policies accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy where the ACL parameter is defined |
|
|
|
|
Owner of the data security policy where the ACL parameter is defined |
|
|
|
|
Name of the ACL |
|
|
|
|
Owner of the ACL |
|
|
|
|
Name of the ACL parameter |
|
|
|
|
Data type of the ACL parameter |
|
|
|
|
Value of the ACL parameter |
|
|
|
|
The order of the realm within the data security policy |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
NA |
Name of the data security policy containing the column constraint |
|
|
|
NA |
Owner of the data security policy containing the column constraint |
|
|
|
NA |
Name of the column that has the column constraint applied to it |
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the data security policy containing the column constraint |
|
|
|
|
Owner of the data security policy containing the column constraint |
|
|
|
|
Name of the column that has the column constraint applied to it |
|
|
|
|
Name of the application privilege required to access the column |
ALL_XS_COLUMN_CONSTRAINTS
The ALL_XS_COLUMN_CONSTRAINTS data dictionary view lists all Real Application Security column constraints accessible to the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
NA |
Name of the data security policy containing the column constraint |
|
|
|
NA |
Owner of the data security policy containing the column constraint |
|
|
|
NA |
Name of the column that has the column constraint applied to it |
|
|
|
NA |
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Schema containing the object |
|
|
|
|
Name of the data security enabled object in the database |
|
|
|
Name of the data security policy associated with the object |
|
|
|
|
|
Owner of the data security policy associated with the object |
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
|
ALL_XS_APPLIED_POLICIES
The ALL_XS_APPLIED_POLICIES data dictionary view displays all database objects on which Real Application Security data security policies are accessible to the current user are enabled.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Schema containing the object |
|
|
|
|
Name of the data security enabled object in the database |
|
|
|
Name of the data security policy associated with the object |
|
|
|
|
|
Owner of the data security policy associated with the object |
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
Policy enabled for |
|
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
NOT NULL |
Name of the data security policy associated with the object |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Application user name of the application session |
|
|
|
|
Application Session identifier |
|
|
|
Name of the proxy application user |
|
|
|
|
The server-unique cookie value associated with the session |
|
|
|
|
|
Creation time for the application session |
|
|
|
|
Last time the application user was authenticated. |
|
|
|
|
Last time that the application session was accessed |
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Application user name of the application session |
|
|
|
|
Application Session identifier |
|
|
|
The database session ID to which the application session is associated. |
|
|
|
|
Name of the proxy application user |
|
|
|
|
The server-unique cookie value associated with the session |
|
|
|
|
|
Creation time for the application session |
|
|
|
|
Last time the application user was authenticated. |
|
|
|
|
Last time that the application session was accessed |
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Application session ID |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Session ID of the application session |
|
|
|
Name of the attribute |
|
|
|
|
|
Name of the namespace |
|
|
|
Value of the attribute |
|
|
|
|
Default value of the attribute |
|
|
|
|
Indicates whether the handler function is invoked when the attribute is first read. Possible values are |
|
|
|
|
Indicates whether the handler function is invoked when the attribute is modified. Possible values are |
DBA_XS_NS_TEMPLATES
The DBA_XS_NS_TEMPLATES data dictionary view describes all Real Application Security namespace templates.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the namespace template |
|
|
|
|
Schema of the namespace handler function |
|
|
|
|
Package containing the namespace handler function |
|
|
|
|
The namespace handler function |
|
|
|
|
Indicates whether the namespace handler function is |
|
|
|
|
Name of ACL for the namespace template. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the attribute defined in the namespace template |
|
|
|
|
Name of the namespace instantiated by the namespace template |
|
|
|
|
Default value of the attribute defined in the namespace template |
|
|
|
|
Indicates whether the namespace handler function is invoked when the attribute is first read. Valid values are |
|
|
|
|
Indicates whether the namespace handler function is invoked when the attribute value is modified. Valid values are |
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
Name of ACL MV for this table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job scheduled to run after the timestamp, if scheduled |
|
|
|
|
The |
|
|
|
|
Number of times this ACL MV has been refreshed so far |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job starting time |
|
|
|
|
The refreshment job ending time |
|
|
|
|
Number of rows have been updated for static ACL sync |
|
|
|
|
Refreshment job status: 0 means success, otherwise an error number is displayed. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job starting time |
|
|
|
|
The refreshment job ending time |
|
|
|
|
Number of rows have been updated for static ACL sync |
|
|
|
|
Refreshment job status: 0 means success, otherwise an error number is displayed. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
Name of ACL MV for this table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job scheduled to run after the timestamp, if scheduled |
|
|
|
|
The |
|
|
|
|
Number of refreshment has been done so far |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job starting time |
|
|
|
|
The refreshment job ending time |
|
|
|
|
Number of rows have been updated for static ACL sync |
|
|
|
|
Refreshment job status: 0 means success, otherwise an error number is displayed. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job starting time |
|
|
|
|
The refreshment job ending time |
|
|
|
|
Number of rows have been updated for static ACL sync |
|
|
|
|
Refreshment job status: 0 means success, otherwise an error number is displayed. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
Name of ACL MV for this table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job scheduled to run after the timestamp, if scheduled |
|
|
|
|
The |
|
|
|
|
Number of refreshment has been done so far |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job starting time |
|
|
|
|
The refreshment job ending time |
|
|
|
|
Number of rows have been updated for static ACL sync |
|
|
|
|
Refreshment job status: 0 means success, otherwise an error number is displayed. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of schema |
|
|
|
|
Name of table |
|
|
|
|
|
|
|
|
|
|
|
|
|
The refreshment job starting time |
|
|
|
|
The refreshment job ending time |
|
|
|
|
Number of rows have been updated for static ACL sync |
|
|
|
|
Refreshment job status: 0 means success, otherwise an error number is displayed. |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the namespace |
|
|
|
|
Name of the workspace space for the namespace |
|
|
|
|
Name of the attribute |
|
|
|
|
Value of the attribute |
|
|
|
|
Events associated with this attribute |
|
|
|
|
Default value for the attribute |
|
|
|
VARCHAR2(4000) |
Type of attribute, either |
|
|
|
|
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
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
The workspace of the application role. |
|
|
|
|
Name of enabled application role |
|
|
|
|
Status flag |
|
|
|
|
Container ID |