Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


DBA_HOST_ACES describes access control entries defined in host access control lists.

Related View

USER_HOST_ACES describes the status of access control entries for the current user to access network hosts through PL/SQL network utility packages. This view does not display the ACE_ORDER, START_DATE, END_DATE, GRANT_TYPE, INVERTED_PRINCIPAL, PRINCIPAL, or PRINCIPAL_TYPE columns.

Column Datatype NULL Description
HOST VARCHAR2(1000) NOT NULL Network host
LOWER_PORT NUMBER(5)   Lower bound of the port range
UPPER_PORT NUMBER(5)   Upper bound of the port range
ACE_ORDER NUMBER NOT NULL Order number of the access control entry
START_DATE TIMESTAMP(6)   Start date of the access control entry
END_DATE TIMESTAMP(6)   End date of the access control entry
GRANT_TYPE VARCHAR2(5)   Indicates whether the access control entry grants or denies the privilege
INVERTED_PRINCIPAL VARCHAR2(3)   Indicates whether the principal is inverted or not
PRINCIPAL VARCHAR2(128)   Principal the privilege is applied to
PRINCIPAL_TYPE VARCHAR2(16)   Type of the principal
PRIVILEGE VARCHAR2(128)   Privilege

See Also: