Oracle ACL

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

set line 160 pagesize 999 tab off trimspool off

col host FORMAT A16
col l_port FORMAT 99999
col u_port FORMAT 99999
col start_date FORMAT A30
col end_date FORMAT A30
col principal FORMAT A20
col principal_type FORMAT A10
col privilege FORMAT A10

SELECT
 dha.host,
 dha.lower_port l_port, dha.upper_port u_port,
 dha.ace_order,
 dha.start_date, dha.end_date,
 dha.grant_type,
 dha.inverted_principal,
 dha.principal,  dha.principal_type,
 dha.privilege
FROM
 dba_host_aces dha
ORDER BY 
 dha.host,  dha.ace_order ;

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

BEGIN
DBMS_NETWORK_ACL_ADMIN.REMOVE_HOST_ACE (
 host => 'mail.domain_name',
 lower_port => 25,
 upper_port => 25,
 ace => xs$ace_type(privilege_list =>xs$name_list('CONNECT'),
 principal_name => 'APEX_200200',
 principal_type => xs_acl.ptype_db),
 remove_empty_acl => TRUE);
END;
/