V$IP_ACL

8.22 V$IP_ACL

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

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).