4.3 Query to Find a User's Allowed IP Address

The DBA_SQL_FIREWALL_ALLOWED_IP_ADDR data dictionary view shows the IP address that a user is allowed to use.

For example:

SELECT IP_ADDRESS FROM DBA_SQL_FIREWALL_ALLOWED_IP_ADDR WHERE USERNAME = 'HR';
 
IP_ADDRESS
------------
192.0.2.1

Related Topics