For more information about Oracle (NYSE:ORCL), visit. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. 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 Before you use a locked account, you must unlock it and reset its password.
When the DBA role is revoked from a user, the same behavior is seen. Oracle Database Release 12.2 Installation Guide for IBM AIX on POWER Systems (64-bit) Unlocking and Resetting Oracle Database User Passwords Passwords for all Oracle system administration accounts except SYS, SYSTEM, and DBSMP are revoked after installation.
Previous versions do not show this behavior. oracledba.help Security / Reset User Password Security Reset User Password ALTER USERThis 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 kommentar(er)
