1. Oracle SQL Firewall User's Guide
  2. Appendix: SQL Firewall Database Views and DBMS Package
  3. SQL Firewall Database Views
  4. DBA_SQL_FIREWALL_ALLOWED_IP_ADDR

A.2 DBA_SQL_FIREWALL_ALLOWED_IP_ADDR

DBA_SQL_FIREWALL_ALLOWED_IP_ADDR lists the IP addresses that SQL Firewall target users are allowed to use to connect to the database.

Column Datatype NULL Description

USERNAME

VARCHAR2(128)

Name of the target user

IP_ADDRESS

VARCHAR2(128)

NOT NULL

Allowed client IP address

Note:

This view is available starting with Oracle Database 23ai.