oracle 11gR2,取消使用者unlimited tablespace 許可權,那麼表空間上的quota也會相應取消
When Revoking Unlimited Tablespace System Privilege Tablespace Quota Also Removed [ID 1169515.1] | |||||
| |||||
修改時間 03-JAN-2011 型別 PROBLEM 狀態 MODERATED |
In this Document
Symptoms
Changes
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform.
Symptoms
If the system privilege unlimited tablespace is revoked from a user, the explicit quota given on tablespaces is also revoked.
This is only seen in version 11.2.0.1 and later.
Previous versions do not show this behavior.
When the DBA role is revoked from a user, the same behavior. is seen.
The behavior. can be reproduced using the following example script, after revoking the system privilege unlimited tablespace the view dba_ts_quotas does not return the expected rows anymore:
connect / as sysdba
drop user tc cascade;
create user tc identified by tc default tablespace users temporary tablespace temp;
select tablespace_name,username,max_bytes from dba_ts_quotas where username='TC';
select * from dba_sys_privs where grantee='TC';
alter user tc quota 100m on users;
select tablespace_name,username,max_bytes from dba_ts_quotas where username='TC';
select * from dba_sys_privs where grantee='TC';
grant unlimited tablespace to TC;
select tablespace_name,username,max_bytes from dba_ts_quotas where username='TC';
select * from dba_sys_privs where grantee='TC';
revoke unlimited tablespace from tc;
select tablespace_name,username,max_bytes from dba_ts_quotas where username='TC';
select * from dba_sys_privs where grantee='TC';
Changes
Database upgraded to version 11.2.0.1Cause
This is expected behavior. for version 11.2 and later.The unlimited tablespace system privilege is a super set of tablespace quotas.
If this privilege is revoked, the user will have to grant quotas to individual tablespaces explicitly.
Note that this behavior. is changed starting version 11.2 and is not seen in previous versions.
This behavior. change is not related to a specific fix.
Solution
After the system privilege unlimited tablespace is revoked, existing quota on individual tablespaces need to be granted again.A request has been made to change the Security Guide on this topic.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9390331/viewspace-718392/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- unlimited tablespace許可權和quota 配額MIT
- 表空間配額和UNLIMITED TABLESPACE許可權MIT
- oracle unlimited tablespace 許可權的用途OracleMIT
- 詳解Oracle的unlimited tablespace系統許可權OracleMIT
- unlimited tablespace許可權的授予和回收MIT
- 系統許可權UNLIMITED TABLESPACE為什麼如此特殊?MIT
- Unlimited Tablespace 許可權 及 “延遲段”特性MIT
- 聊聊Oracle可傳輸表空間(Transportable Tablespace)(上)Oracle
- Oracle檢視使用者預設表空間、臨時表空間、系統許可權、物件許可權、角色許可權舉例說明Oracle物件
- Oracle建立表空間、使用者、分配許可權語句Oracle
- Oracle 建立表空間、建立使用者以及授權、檢視許可權Oracle
- oracle建立使用者,表空間,臨時表空間,分配許可權步驟詳解Oracle
- 使用者有connect,resource,dba角色許可權後回收dba許可權導致無UNLIMITED TABLESPACE許可權造成業務中斷MIT
- 取消 root 級管理員的 root 許可權
- Oracle的表空間quota詳解Oracle
- oracle的表空間quota詳講Oracle
- Oracle建立表空間、建立資料庫使用者、賦許可權Oracle資料庫
- 【轉】使用Navicat for Oracle新建表空間、使用者及許可權賦予Oracle
- 聊聊Oracle可傳輸表空間(Transportable Tablespace)(中)Oracle
- 聊聊Oracle可傳輸表空間(Transportable Tablespace)(下)Oracle
- Oracle資料泵建立使用者避坑(表空間配額、許可權)Oracle
- Oracle 11gR2 注意revoke dba 會一併回收通過”quota“分配的表空間限額Oracle
- Oracle建立表空間、建立使用者、授權、授權物件的訪問以及檢視許可權集合Oracle物件
- win10管理員許可權怎麼取消_win10如何關掉管理員許可權Win10
- oracle建立/刪除表空間、建立/刪除使用者並賦予許可權Oracle
- oracle的臨時表空間temporary tablespaceOracle
- ORACLE如何檢視錶空間路徑及使用者許可權Oracle
- 【TABLESPACE】Oracle表空間最佳實踐Oracle
- Oracle基礎 01 表空間 tablespaceOracle
- 臨時表空間temporary tablespace相關操作
- 複製建立已有資料庫使用者、表空間、許可權的指令碼資料庫指令碼
- Oracle中使用者、角色、與許可權涉及的相關表及檢視Oracle
- Oracle 使用者、物件許可權、系統許可權Oracle物件
- 【TABLESPACE】Oracle 表空間結構說明Oracle
- 【Oracle】oracle tablespace&datafile -- oracle表空間 分享[轉]Oracle
- oracle使用者許可權Oracle
- oracle 使用者許可權Oracle
- Oracle的表空間、使用者和使用者授權Oracle