Oracle ACL

acl 관련 패키지
dbms_network_acl_admin

-- User 에게 utl_http 권한부여
grant execute on utl_http to [username];

-- 메일발송 Connect 권한 생성
exec dbms_network_acl_admin.create_acl(acl => '/sys/acls/utl_mail.xml', description => 'UTL Mail Access',  principal => '[username]', is_grant => true, privilege => 'connect', start_date => null, end_date => null );
commit;

-- 메일발송 resolve 권한 추가
exec dbms_network_acl_admin.add_privilege(acl => '/sys/acls/utl_mail.xml', principal => '[username]', is_grant => true, privilege => 'resolve');
commit;

--  메일서버 정보 추가
exec dbms_network_acl_admin.accign_acl( acl=> '/sys/acls/utl_mail.xml', host => '[IP_address]', lower_port => null, upper_port => null);
commit;

-- acl설정 조회
select * from dba_netowkr_acls;
select * from dba_network_acl_privileges;

-- acl 설정 삭제
exec dbms_network_acl_admin.drop_acl(acl => '/sys/acls/utl_mail.xml');