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

VIEW: SYS.USER_NETWORK_ACL_PRIVILEGES

Object Details
Object Name: USER_NETWORK_ACL_PRIVILEGES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

User privileges to access network hosts through PL/SQL network utility packages

[View Source]

Columns
Name Datatype Length Mandatory Comments
HOST VARCHAR2 (1000) Yes Network host
LOWER_PORT NUMBER (5)
Lower bound of the port range
UPPER_PORT NUMBER (5)
Upper bound of the port range
PRIVILEGE VARCHAR2 (128)
Privilege
STATUS VARCHAR2 (7)
Privilege status
Query Text

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


SELECT HOST
,      LOWER_PORT
,      UPPER_PORT
,      PRIVILEGE
,      STATUS
FROM SYS.USER_NETWORK_ACL_PRIVILEGES;

Dependencies

[top of page]

SYS.USER_NETWORK_ACL_PRIVILEGES references the following:

SchemaSYS
ViewDBA_XS_OBJECTS
TableNACL$_HOST
SYS.USER_NETWORK_ACL_PRIVILEGES is referenced by following:

SchemaPUBLIC
SynonymUSER_NETWORK_ACL_PRIVILEGES