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_NETWORK_ACL_PRIVILEGES

Object Details

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

Privileges defined in network access control lists

[View Source]

Columns

Name	Datatype	Length	Comments
ACL	VARCHAR2	(4000)	The name of the access control list
ACLID	RAW	(8)	The object ID of the access control list
PRINCIPAL	VARCHAR2	(128)	Principal the privilege is applied to
PRIVILEGE	VARCHAR2	(128)	Privilege
IS_GRANT	VARCHAR2	(5)	Is the privilege granted or denied
INVERT	VARCHAR2	(5)	true if the access control entry contains invert principal, false otherwise
START_DATE	TIMESTAMP(6)	(11)	Start-date of the access control entry
END_DATE	TIMESTAMP(6)	(11)	End-date of the access control entry
ACL_OWNER	VARCHAR2	(128)	The owner of the access control list

Query Text

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


SELECT ACL
,      ACLID
,      PRINCIPAL
,      PRIVILEGE
,      IS_GRANT
,      INVERT
,      START_DATE
,      END_DATE
,      ACL_OWNER
FROM SYS.DBA_NETWORK_ACL_PRIVILEGES;

Dependencies

[top of page]

SYS.DBA_NETWORK_ACL_PRIVILEGES references the following:

SYS: DBA_XS_ACES; DBA_XS_OBJECTS; NACL$_HOST; NACL$_NAME_MAP

SYS.DBA_NETWORK_ACL_PRIVILEGES is referenced by following:

PUBLIC: DBA_NETWORK_ACL_PRIVILEGES