ALTER SYSTEM set smtp_out_server = 'mail.irvineplus.com:26' SCOPE = BOTH;
--------------------------------------------------------------------------
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => 'utl_smtp.xml',
host => 'mail.irvineplus.com',
lower_port => 1,
upper_port => 10000);
commit;
end;
/
--------------------------------------------------------------------------
BEGIN
dbms_network_acl_admin.add_privilege(acl=> 'utl_smtp.xml',
principal => 'CHADMOON',
is_grant => TRUE,
privilege => 'resolve',
start_date => null,
end_date => null);
commit;
end;
/
-----------------------------------------------------------------------------
BEGIN
DBMS_NETWORK_ACL_ADMIN.unassign_acl (
acl => 'utl_smtp.xml',
host => '');
COMMIT;
END;
/
-------------------------------------------------------------------------------
| Server Name: |
email-smtp.us-west-2.amazonaws.com
|
| Port: | 25, 465 or 587 |
| Use Transport Layer Security (TLS): | Yes |
| Authentication: | Your SMTP credentials. See below for more information. |
| No. | Subject |
|---|---|
| Notice | Certification Oracle SQL Developer |
| 114 | 5.6.2 Granting Connect Privileges Prior to Oracle Database 12c |
| 113 | lsnrctl start |
| 112 | Network access denied by access control list (ACL) in Oracle Database 11g |
| 111 | email - PL/SQL |
| 110 | MODIFY |
| 109 | CREATE |
| 108 | PORT CHANGE 8080 --> 8081 |
| 107 |
About AMAZON
 |
| 106 |
BUXOMCURVY
|
| 105 | WHDR(LAYOUT) CODE |
| 104 | CREATE?MODIFY |
| 103 | SEND GRID |
| 102 | MAILJET |
| 101 | DATA BASE LINK |
| 100 | dbms_network_acl_admin |
| 99 | Samsung-NP300E5E-DDR3 |
| » | Config |
| 97 | APEX_MAIL.SEND |
| 96 | grant execute on UTL_TCP |
| 95 | Email SMTP |
