ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 详解Oracle的unlimited tablespace系统权限

详解Oracle的unlimited tablespace系统权限

原创 Linux操作系统 作者:victorymoshui 时间:2012-03-13 00:12:28 0 删除 编辑

1. 系统权限unlimited tablespace是隐含在dba, resource角色中的一个系统权限. 当用户得到dba或resource的角色时, unlimited tablespace系统权限也隐式受权给用户.

2. 系统权限unlimited tablespace不能被授予role, 可以被授予用户.

3. 系统权限unlimited tablespace不会随着resource, dba被授予role而授予给用户.

1 实验1

SQL> create user u1 identified by u1;

User created.

SQL> grant connect, resource to u1;

Grant succeeded.

SQL> select * from dba_role_privs a where a.grantee='U1';

GRANTEE              GRANTED_ROLE         ADM DEF

-------------------- -------------------- --- ---

U1                   RESOURCE             NO  YES

U1                   CONNECT              NO  YES

SQL> select * from dba_sys_privs a where a.grantee='U1';

GRANTEE              PRIVILEGE            ADM

-------------------- -------------------- ---

U1                   UNLIMITED TABLESPACE NO

SQL> revoke unlimited tablespace from u1;

Revoke succeeded.

SQL> select * from dba_sys_privs a where a.grantee='U1';

no rows selected

2 实验2

SQL> create role r1;

Role created.

SQL> grant unlimited tablespace to r1;

ORA-01931: cannot grant UNLIMITED TABLESPACE to a role

不能受权给角色r1.

 

SQL> grant unlimited tablespace to u1;

Grant succeeded.

可以受权给用户u1.

3 实验3

SQL> revoke resource from u1;

Revoke succeeded.

SQL> grant resource to r1;

Grant succeeded.

SQL> grant r1 to u1;

Grant succeeded.

SQL> select * from dba_role_privs a where a.grantee='U1';

GRANTEE              GRANTED_ROLE         ADM DEF

-------------------- -------------------- --- ---

U1                   R1                   NO  YES

U1                   CONNECT              NO  YES

SQL> select * from dba_sys_privs a where a.grantee='U1';

no rows selected

系统权限中没有unlimit tablespace系统权限.

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

请登录后发表评论 登录
全部评论

注册时间:2009-08-26

  • 博文量
    173
  • 访问量
    302080