ERPstuff - Oracle EBS Community

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;