DBA_XS_OBJECTS

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

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