Shulou(Shulou.com)06/01 Report--

-- create an ACL

BEGIN

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (

Acl = > 'email_server_permissions.xml'

Description = > 'Enables network permissions for the e-mail server'

Principal = > 'email_user'

Is_grant = > TRUE

Privilege = > 'connect')

END

/

-- Associated with the mail service

BEGIN

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (

Acl = > 'email_server_permissions.xml'

Host = > 'smtp_server'

Lower_port = > port)

END

/

This allows stored procedures created by the email_user user account to send messages to this mail server

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.