Get ACL details in database - Oracle Database Script.
SET lines 200 COL ACL_OWNER
FOR A12 COL ACL
FOR A67 COL HOST
FOR A34 col PRINCIPAL
FOR a20 col PRIVILEGE
FOR a13
SELECT ACL_OWNER,
ACL,
HOST,
LOWER_PORT,
UPPER_PORT
FROM dba_network_acls;
SELECT ACL_OWNER,
ACL,
PRINCIPAL,
PRIVILEGE
FROM dba_network_acl_privileges;