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

VIEW: SYS.USER_HOST_ACES

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

Status of access control entries for user to access network hosts through PL/SQL host 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_HOST_ACES;

Dependencies

[top of page]

SYS.USER_HOST_ACES references the following:

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

SchemaPUBLIC
SynonymUSER_HOST_ACES