How to find the existing network ACLs and proxies in oracle database

 

Use below query to find the existing network ACLs in oracle database.

Network ACLs:

col owner for a15
col host for a30
col acl for a55
set lines 500

select * from dba_network_acls;

Database Proxies

col proxy for a15

col client for a15

col authentication for a15

col role for a15

col proxy_authority for a15

set lines 500

select * from dba_proxies where proxy like 'XYZ';

Thanks for going through the post........