Dynamic Data Masking Accelerator Guide for use with SAP

Dynamic Data Masking Accelerator Guide for use with SAP

Create Access Control List for Oracle 11G

Create Access Control List for Oracle 11G

If you have an Oracle 11G database, you must create an access control list to enable an outgoing network with utl_http.
A database administrator must create the access control list because it impacts applications that use utl_http.
Use the following script to create the access control list:
begin DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => 'www.xml', --access control list file name (.xml) description => 'Permissions to access tomcat', principal => 'SYSTEM', --replace with the DDM user is_grant => TRUE, privilege => 'connect'); COMMIT; DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl => ‘www.xml', --the file name you gave in the precedent command host => '*'); --which host is available for the access control COMMIT; End ;