5.94 DBA_HOST_ACES

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:

"USER_HOST_ACES"