ACL Settings

[admin]

ACL (Access Control List) is used to give access in Oracle Database to access remote machine like Exchange server etc. For more details about ACL view the following URL,

http://docs.oracle.com/cd/B28359_01/app ... m#CHDCFDEF

Login as SYS

-- Creation
DECLARE
l_acl VARCHAR2(100) := 'ERPstuff.xml';
l_desc VARCHAR2(100) := 'Oracle 11g ACL Access';
l_principal VARCHAR2(30) := 'APEX_050000'; -- In upper case
l_host VARCHAR2(100) := '192.168.1.55'; -- IP or host name but host name should be accessible
BEGIN
dbms_network_acl_admin.create_acl(l_acl, l_desc, l_principal, TRUE, 'connect');
dbms_network_acl_admin.add_privilege(l_acl, l_principal, TRUE, 'resolve');
dbms_network_acl_admin.assign_acl(l_acl, l_host);

COMMIT;
END;

-- Dropping
BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
acl => 'ERPstuff.xml');

COMMIT;
END;

-- View
select host, lower_port, upper_port, acl from dba_network_acls;