exec DBMS_NETWORK_ACL_ADMIN.DROP_ACL(‘utlmailpkg.xml’);
2. Create and Assign ACL TO DBUSER and Assign it all host.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => ‘NETWORK_SERVICES.xml’,
description => ‘ACL Access’,
principal => ‘DB’,
is_grant => true,
privilege => ‘connect’);
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => ‘NPP_NETWORK_SERVICES.xml’,
principal => ‘NPP’,
is_grant => true,
privilege => ‘resolve’);
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => ‘NPP_NETWORK_SERVICES.xml’,
host => ‘*’);
COMMIT;
END;
/3. Adding ACL privilege to NPPWEBexec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => ‘NPP_NETWORK_SERVICES.xml’, principal => ‘NPPWEB’, is_grant => true, privilege => ‘connect’);exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => ‘NPP_NETWORK_SERVICES.xml’, principal => ‘NPPWEB’, is_grant => true, privilege => ‘resolve’);4. smtp_out_server parameter settings alter system set smtp_out_server=’localhost:25′ scope=BOTH;5. To Test the ACL Accessconn NPP/SQL> select utl_http.request(‘http://www.oracle.com’) from dual;
UTL_HTTP.REQUEST(‘HTTP://WWW.ORACLE.COM’)——————————————————————————–http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
“>
http://www.w3.org/1999/xhtml”>
var _U = “undefined”; var g_HttpRelativeWebRoot = “/ocom/”; var SSContributor = false; var SSForceContributor = false; var SSHideContributorUI = false;
UTL_HTTP.REQUEST(‘HTTP://WWW.ORACLE.COM’)——————————————————————————– var ssUrlPrefix = “/us/”; var ssUrlType = “2”;
var g_navNode_Path = new Array(); g_navNode_Path[0] = ‘8’; var g_ssSourceNodeId = “8”; var g_ssSourceSiteId = “ocomen”;
UTL_HTTP.REQUEST(‘HTTP://WWW.ORACLE.COM’)——————————————————————————–
