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