oracle resource分析

当把resource授予一个role时，就不会授予unlimited tablespace权限

1.SQL> conn desk
2.Enter password:
3.Connected.
4.SQL> select PRIVILEGE from user_sys_privs;
5.no rows selected
6.SQL> conn / as sysdba
7.Connected.
8.SQL> grant resource to desk;
9.Grant succeeded.
10.SQL> conn desk
11.Enter password:
12.Connected.
13.SQL> select PRIVILEGE from user_sys_privs;
14.PRIVILEGE
15.----------------------------------------
16. UNLIMITED TABLESPACE

当把resource授予一个role时，就不会授予unlimited tablespace权限

1.SQL> show user 

2.USER is "SYS" 

3.SQL> create role testrole identified using testrole; 

4.Role created. 

5.SQL> revoke resource from desk; 

6.Revoke succeeded. 

7.SQL> grant resource to testrole; 

8.Grant succeeded. 

9.SQL> grant testrole to desk; 

10.Grant succeeded. 

11.SQL> conn desk 

12.Enter password: 

13.Connected. 

14.SQL> select privilege from user_sys_privs; 

15.no rows selected 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26162300/viewspace-731640/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26162300/viewspace-731640/