grant execute on dbms_network_acl_admin to OPERA;


begin
dbms_network_acl_admin.drop_acl(
'open_acl_file.xml'
);
end;
/


BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'open_acl_file.xml',
description => 'OPERA for ACL functionality',
principal => 'OPERA',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'open_acl_file.xml',
host => '*',
lower_port => NULL,
upper_port => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'open_acl_file.xml',
principal => 'OPERA',
is_grant => TRUE,
privilege => 'connect',
position => NULL,
start_date => SYSTIMESTAMP,
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'open_acl_file.xml',
principal => 'OPERA',
is_grant => TRUE,
privilege => 'use-client-certificates');
commit;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'open_acl_file.xml',
principal => 'OPERA_TRAIN',
is_grant => TRUE,
privilege => 'connect',
position => NULL,
start_date => SYSTIMESTAMP,
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'open_acl_file.xml',
principal => 'OXI',
is_grant => TRUE,
privilege => 'connect',
position => NULL,
start_date => SYSTIMESTAMP,
end_date => NULL);
COMMIT;
END;
/