Oracle sends mail, permissions issues

-- Create ACL

BEGIN

Dbms_network_acl_admin. Create_acl(ACL =' Email_server_permissions.xml ',

Description=' Enables network permissionsfor the E- mail server ',

Principal =' Ljz ',

Is_grant =TRUE,

Privilege=' Connect ');

END;

?

-- associating with a mail service

BEGIN

Dbms_network_acl_admin. Assign_acl(ACL =' Email_server_permissions.xml ',

Host =' smtp.163.com ',

Lower_port =,

Upper_port =NULL);

END;

-- this Email_user A stored procedure created by a user account can send mail to this mail server

?

-- Delete

BEGIN

Dbms_network_acl_admin.drop_acl(ACL =' Email_server_permissions.xml ');

COMMIT;

END;

-- Enquiry

SELECT host, lower_port, upper_port, ACL from dba_network_acls;

SELECT ACL,

Principal,

Privilege,

Is_grant,

To_char(start_date,' dd-mon-yyyy ') as Start_date,

To_char(end_date,' dd-mon-yyyy ')as end_date

From dba_network_acl_privileges;

Oracle sends mail, permissions issues