Thursday, 25 July 2019

ACL

SQL> begin
DBMS_NETWORK_ACL_ADMIN.create_acl(
acl => '/sys/acls/AddressDoc.xml',
description=>'ACL for UTL_MAIL',
principal=>'STAT_CUSTGOV',
is_grant=>TRUE,
privilege=>'connect');
COMMIT;
End;
/  2    3    4    5    6    7    8    9   10

PL/SQL procedure successfully completed.

SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => '/sys/acls/AddressDoc.xml',
host => '*');
COMMIT;
END;
/  2    3    4    5    6    7

PL/SQL procedure successfully completed.

SQL> BEGIN
        DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
          acl   => '/sys/acls/AddressDoc.xml',
          principal => 'STAT_CUSTGOV',
          is_grant  => TRUE,
          privilege => 'connect');
END;


PL/SQL procedure successfully completed.

No comments:

Post a Comment

Featured post

duplicate db from standy to other server

 Duplicate Testuat   $ export ORACLE_SID=Testuat3 $ sqlplus '/as sysdba' Testuat3 SQL> alter system set cluster_database=FALSE sc...