1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_SQL_FIREWALL_ALLOWED_IP_ADDR

6.411 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.