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.XDS_ACE

Object Details

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

All ACEs in ACLs that are visible to the current user in the database

[View Source]

Columns

Name	Datatype	Length	Comments
ACLID	RAW	(16)	The ACL ID of an ACL
START_DATE	TIMESTAMP(0)	(4000)	The start_date attribute of the ACE
END_DATE	TIMESTAMP(0)	(4000)	The end_date attribute of the ACE
IS_GRANT	VARCHAR2	(5)	true if this is a grant ACE, false otherwise
INVERT	VARCHAR2	(5)	true if this ACE contains invert principal, false otherwise
PRINCIPAL	VARCHAR2	(4000)	The principal in this ACE
PRIVILEGE	XMLTYPE	(64)	The privileges in this ACE

Query Text

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


SELECT ACLID
,      START_DATE
,      END_DATE
,      IS_GRANT
,      INVERT
,      PRINCIPAL
,      PRIVILEGE
FROM SYS.XDS_ACE;

Dependencies

[top of page]

SYS.XDS_ACE references the following:

SYS: STANDARD - show dependent code; XMLSEQUENCE; XMLSEQUENCEFROMXMLTYPE; XMLSEQUENCETYPE; XMLTYPE
XDB: XDB$ACL

SYS.XDS_ACE is referenced by following:

PUBLIC: XDS_ACE