6.520 USER_NETWORK_ACL_PRIVILEGES

USER_NETWORK_ACL_PRIVILEGES describes the status of the network privileges for the current user to access network hosts.

Note:

This USER_NETWORK_ACL_PRIVILEGES view is deprecated in Oracle Database 12c Release 1 (12.1). Oracle recommends that you use the USER_HOST_ACES view, instead.

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

PRIVILEGE

CHAR(128)

Network privilege

STATUS

VARCHAR2(7)

Privilege status:

  • DENIED

  • GRANTED

See Also:

"USER_HOST_ACES"