Oracle ACL(Access Control List)

1

2

3

<font face="NSimsun">SELECT</font> utl_inaddr.get_host_address FROM <font face="NSimsun">dual;  //获取IP </font>

<font face="NSimsun"> </font> 

<font face="NSimsun">SELECT</font>  utl_inaddr.get_host_name FROM <font face="NSimsun">dual; //获取host 名字</font>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

<font face="NSimsun">BEGIN</font>

<font face="NSimsun"> </font> 

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'abc.xml', --这个xml文件名字随便取的,但不同出现同名的情况

<font face="NSimsun"> </font> 

description => 'ACL list',

<font face="NSimsun"> </font> 

principal => 'ARWEN', --表示赋予权限给哪个用户

<font face="NSimsun"> </font> 

is_grant => true, --为true表示赋予权限,如果是false相当取消权限

<font face="NSimsun"> </font> 

privilege => 'connect');

<font face="NSimsun"> </font> 

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'abc.xml',

<font face="NSimsun"> </font> 

principal => 'ARWEN',

<font face="NSimsun"> </font> 

is_grant => true,

<font face="NSimsun"> </font> 

privilege => 'resolve');

<font face="NSimsun"> </font> 

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'abc.xml',

<font face="NSimsun"> </font> 

host => 'Oracle_Host_name'); --因为那些网络操作的权限是针对某一个server的,所以这里是指定一台机器的名字

<font face="NSimsun"> </font> 

END;

1

2

3

4

5

<font face="NSimsun">BEGIN</font>

<font face="NSimsun"> </font> 

DBMS_NETWORK_ACL_ADMIN.drop_acl ( acl => 'abc.xml');

<font face="NSimsun"> </font> 

END;