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;
ACL Settings
Who is online
Users browsing this forum: No registered users and 2 guests