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
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博客 ” ，链接：https://blog.itpub.net/26162300/viewspace-731640/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
rman备份会视test为关键字
下一篇：
OGG-01476
请登录后发表评论
登录
全部评论
