eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_XS_ACES

Object Details

Object Name:	DBA_XS_ACES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All the Real Application Security ACES defined in database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACL	VARCHAR2	(128)		Name of the ACL
OWNER	VARCHAR2	(128)		Owner of the ACL
ACE_ORDER	NUMBER		Yes	Order number of the ACE in the ACL
START_DATE	TIMESTAMP(6)	(11)		Effective start date of the ACE
END_DATE	TIMESTAMP(6)	(11)		Effective end date of the ACE
GRANT_TYPE	VARCHAR2	(5)		Indicates whether the ACE GRANT or DENY the privileges
INVERTED_PRINCIPAL	VARCHAR2	(3)		Indicates whether the principal is inverted (YES) or not (NO)
PRINCIPAL	VARCHAR2	(128)
PRINCIPAL_TYPE	VARCHAR2	(11)		Type of the principal
PRIVILEGE	VARCHAR2	(128)		Name of the 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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACL
,      OWNER
,      ACE_ORDER
,      START_DATE
,      END_DATE
,      GRANT_TYPE
,      INVERTED_PRINCIPAL
,      PRINCIPAL
,      PRINCIPAL_TYPE
,      PRIVILEGE
,      SECURITY_CLASS
,      SECURITY_CLASS_OWNER
FROM SYS.DBA_XS_ACES;

Dependencies

[top of page]

SYS.DBA_XS_ACES references the following:

SYS: USER$; XS$ACE; XS$ACE_PRIV; XS$ACL; XS$OBJ

SYS.DBA_XS_ACES is referenced by following:

PUBLIC: DBA_XS_ACES
SYS: DBA_HOST_ACES; DBA_NETWORK_ACL_PRIVILEGES; DBA_WALLET_ACES; DBMS_NETWORK_ACL_ADMIN - show dependent code; NACL$_ACE_EXP; USER_XS_ACES