帶您了解ORACLE resource角色
作者：佚名
ORACLE數據庫中，不同的角色的權限是不一樣的，下文對resource角色作了詳細的介紹，如果您對此感興趣的話，不妨一看。
ORACLE resource角色都有什么樣的權限呢？下面就為您介紹如何查看ORACLE resource角色的權限的方法，希望對您能有所幫助。
- SQL> select * from v$version where rownum<=1;
- BANNER
- --------------------------------------------------------------------------------
- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
從role_sys_privs中看ORACLE resource角色的權限
- SQL> select PRIVILEGE from role_sys_privs where role='RESOURCE';
- PRIVILEGE
- --------------------------------------------------------------------------------
- CREATE CLUSTER
- CREATE SEQUENCE
- CREATE TRIGGER
- CREATE TABLE
- CREATE PROCEDURE
- CREATE TYPE
- CREATE OPERATOR
- CREATE INDEXTYPE
- 8 rows selected.
當把ORACLE resource角色授予一個user的時候，不但會授予ORACLE resource角色本身的權限，而且還有unlimited tablespace權限。
- SQL> conn desk
- Enter password:
- Connected.
- SQL> select PRIVILEGE from user_sys_privs;
- no rows selected
- SQL> conn / as sysdba
- Connected.
- SQL> grant resource to desk;
- Grant succeeded.
- SQL> conn desk
- Enter password:
- Connected.
- SQL> select PRIVILEGE from user_sys_privs;
- PRIVILEGE
- ----------------------------------------
- UNLIMITED TABLESPACE
- SQL>
當把resource授予一個role時，就不會授予unlimited tablespace權限
- SQL> show user
- USER is "SYS"
- SQL> create role testrole identified using testrole;
- Role created.
- SQL> revoke resource from desk;
- Revoke succeeded.
- SQL> grant resource to testrole;
- Grant succeeded.
- SQL> grant testrole to desk;
- Grant succeeded.
- SQL> conn desk
- Enter password:
- Connected.
- SQL> select privilege from user_sys_privs;
- no rows selected
- SQL>
【編輯推薦】
【編輯推薦】
責任編輯：段燃
來源：
互聯網
