帶您了解ORACLE resource角色
作者：佚名
ORACLE數(shù)據(jù)庫(kù)中，不同的角色的權(quán)限是不一樣的，下文對(duì)resource角色作了詳細(xì)的介紹，如果您對(duì)此感興趣的話，不妨一看。
ORACLE resource角色都有什么樣的權(quán)限呢？下面就為您介紹如何查看ORACLE resource角色的權(quán)限的方法，希望對(duì)您能有所幫助。
- 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角色的權(quán)限
- 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.
當(dāng)把ORACLE resource角色授予一個(gè)user的時(shí)候，不但會(huì)授予ORACLE resource角色本身的權(quán)限，而且還有unlimited tablespace權(quán)限。
- 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>
當(dāng)把resource授予一個(gè)role時(shí)，就不會(huì)授予unlimited tablespace權(quán)限
- 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>
【編輯推薦】
oracle數(shù)據(jù)導(dǎo)出和導(dǎo)入的權(quán)限
【編輯推薦】
oracle數(shù)據(jù)導(dǎo)出和導(dǎo)入的權(quán)限
責(zé)任編輯：段燃
來(lái)源：
互聯(lián)網(wǎng)
