forked from teopost/oracle-scripts
-
Notifications
You must be signed in to change notification settings - Fork 0
/
gen_acl_script.sql
21 lines (21 loc) · 739 Bytes
/
gen_acl_script.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
select
'BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL
(acl => '''||acl||''','||'principal => '''||PRINCIPAL||''','||'is_grant => ' ||
IS_GRANT||','||'privilege => '''||PRIVILEGE||'''); commit; END;'
from dba_NETWORK_ACL_PRIVILEGES
where privilege='connect'
union all
select
'BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
(acl => '''||acl||''','||'principal => '''||PRINCIPAL||''','||'is_grant => ' ||
IS_GRANT||','||'privilege => '''||PRIVILEGE||'''); commit; END;'
from dba_NETWORK_ACL_PRIVILEGES
where privilege<>'connect'
union all
select
'BEGIN DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (acl => '''||acl||''', '||
'host => '''||host||''', '||
'lower_port => '||lower_port||', '||
'upper_port => '||upper_port||'); commit; END;'
from dba_NETWORK_ACLS
/