Oracle 视图 DBA_NETWORK_ACL_PRIVILEGES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_NETWORK_ACL_PRIVILEGES用于查看网络访问控制列表(ACL)中授予给用户的权限。ACL允许系统管理员控制哪些用户可以访问哪些网络接口（例如服务器，ssl端口）。
要使用DBA_NETWORK_ACL_PRIVILEGES视图，您需要首先创建所需的授权。可以使用DBMS_NETWORK_ACL_ADMIN包来完成，该包可以帮助您定义特定的网络IP地址，可以控制谁可以访问该地址，以及可以访问的权限类型。然后，可以使用以下查询来检查特定用户的授权：
SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES WHERE host LIKE ‘%’ AND lower_port = PORT_NUMBER AND ACL IN (SELECT ACL FROM DBA_NETWORK_ACLS WHERE ACL LIKE ‘%USER_NAME%’)
此查询将显示有关特定用户可以访问特定网络接口的所有信息，包括网络IP地址，端口号，以及授权的权限类型。
官方英文解释
DBA_NETWORK_ACL_PRIVILEGES describes the network privileges defined in all access control lists that are currently assigned to network hosts.
Note:
This DBA_NETWORK_ACL_PRIVILEGES view is deprecated in Oracle Database 12c Release 1 (12.1). Oracle recommends that you use the DBA_HOST_ACES view, instead.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Path of the access control list |
|
|
|
|
|
Object ID of the access control list |
|
|
|
Principal (database user or role) whom the privilege is granted to or denied from |
|
|
|
|
Network privilege |
|
|
|
|
Indicates whether the privilege is granted ( |
|
|
|
|
Indicates whether the access control entry contains invert principal ( |
|
|
|
|
Start date of the access control entry |
|
|
|
|
End date of the access control entry |
|
|
|
|
Owner of the access control list |
See Also:
“DBA_HOST_ACES”
