Oracle發郵件，許可權問題

標籤：

-- 建立 ACL

BEGIN

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl =>‘email_server_permissions.xml‘,

description=>‘Enables network permissions for the e-mail server‘,

principal =>‘LJZ‘,

is_grant =>TRUE,

privilege=>‘connect‘);

END;

?

-- 與郵件服務關聯

BEGIN

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl =>‘email_server_permissions.xml‘,

host =>‘smtp.163.com‘,

lower_port =>25,

upper_port =>NULL);

END;

-- 這樣 email_user 使用者帳戶建立的預存程序便可以向此郵件伺服器發送郵件

?

--刪除

BEGIN

DBMS_NETWORK_ACL_ADMIN.drop_acl(acl =>‘email_server_permissions.xml‘);

COMMIT;

END;

--查詢

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發郵件，許可權問題