Skip to content

Instantly share code, notes, and snippets.

@mortenbra

mortenbra/ora_network_acl_verify.sql

Created June 4, 2015 14:39
Show Gist options
  • Save mortenbra/3defc6b562db23e61243 to your computer and use it in GitHub Desktop.
Save mortenbra/3defc6b562db23e61243 to your computer and use it in GitHub Desktop.
Download ZIP
Verify network ACL settings in Oracle
Raw
ora_network_acl_verify.sql
-- check/verify network ACL settings
select host, lower_port, upper_port, acl
from dba_network_acls;
select *
from dba_network_acl_privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment