CONN HR/HR@LIVE BEGIN DBMS_NETWORK_ACL_ADMIN.drop_acl ( acl => 'power_users_apex.xml'); COMMIT; END; / begin DBMS_NETWORK_ACL_ADMIN.create_acl( acl => 'power_users_apex.xml', description => 'Access to Apex Email', principal=>'APEX_200200', IS_GRANT=>TRUE, PRIVILEGE=>'connect', START_DATE=>SYSTIMESTAMP, END_DATE=>NULL); COMMIT; end; / begin DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE( acl => 'power_users_apex.xml', principal=>'APEX_200200', IS_GRANT=>TRUE, PRIVILEGE=>'resolve'); COMMIT; end; / begin DBMS_NETWORK_ACL_ADMIN.assign_acl( acl => 'power_users_apex.xml', host=>'mail.ubs-bd.com', lower_port=>26, upper_port=>null); COMMIT; end; / Now Go to Internal Workspace >>Instance Settings>>Email Tab>> SMTP Host Address : mail.ubs-bd.com SMTP Host Port : 26 SMTP Authentication Username : prince@ubs-bd.com SMTP Authentication Password : xxxyyyxxxxxxx Default Email From Address : prince@ubs-bd.com
https://www.youtube.com/watch?v=Fks0nJJ2Oto
No comments:
Post a Comment