当把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
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/