My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! Select * from dba_sys_privs where grantee='' Changesĭatabase upgraded to version 11.2.0.1 Cause Sign In Select * from dba_sys_privs where grantee='' Select tablespace_name,username,max_bytes from dba_ts_quotas where username='' 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:Ĭreate user identified by default tablespace users temporary tablespace temp When the DBA role is revoked from a user, the same behavior is seen. Previous versions do not show this behavior. This is only seen in version 11.2.0.1 and later (and if compatible=11.2.0 or higher ). If the system privilege unlimited tablespace is revoked from a user, the explicit quota given on tablespaces is also revoked. Information in this document applies to any platform. Oracle Database - Enterprise Edition - Version 11.2.0.1 and later When Revoking Unlimited Tablespace System Privilege Tablespace Quota Also Removed
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |