Oracle 视图 V$IP_ACL 官方解释，作用，如何使用详细说明-云搜网

本站中文解释

Oracle视图V$IP_ACL是一个传输控制协议（TCP）配置的视图，它反映系统参数文件（SPFILE）中定义的IP访问控制列表（ACL）清单。通过它可以查看被添加到ACL中的IPv4/IPv6地址、子网掩码地址、访问模式，以及相关实例等信息。

使用方法:

1. 使用SQL*Plus连接到Oracle数据库，然后使用SELECT语句从V$IP_ACL视图中查询IP访问控制列表：

SELECT * FROM V$IP_ACL;

2. 使用ALTER SYSTEM语句添加或删除IP访问控制：

ALTER SYSTEM SET ip_acl_parameters = ‘{ip_address,mask_size,[ALLOW|DENY]}'[,…] SCOPE=SPFILE;

官方英文解释

V$IP_ACL provides information about access control to database services from network hosts.

Column Datatype Description

Column	Datatype	Description
`SERVICE_NAME`	`VARCHAR2(512)`	The database service name
`HOST`	`VARCHAR2(64)`	The host being granted access to the `SERVICE_NAME`. The host can be a hostname, dotted-decimal IPv4 or heximal IPv6 address. Wildcard “*” for IPv4 and Classless Inter-Domain Routing (CIDR) format is allowed.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs `1`: This value is used for rows containing data that pertain only to the root n: Where n is the applicable container ID for the rows containing data

SERVICE_NAME

VARCHAR2(512)

The database service name

HOST

VARCHAR2(64)

The host being granted access to the SERVICE_NAME. The host can be a hostname, dotted-decimal IPv4 or heximal IPv6 address. Wildcard “*” for IPv4 and Classless Inter-Domain Routing (CIDR) format is allowed.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs
1: This value is used for rows containing data that pertain only to the root
n: Where n is the applicable container ID for the rows containing data

Oracle 视图 V$IP_ACL 官方解释，作用，如何使用详细说明

本站中文解释

官方英文解释

相关推荐

热门推荐

分类目录