Revoke Unlimited Tablespace From a role Raise ORA-01952 in version 220.127.116.11
Last updated on OCTOBER 21, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
When you try to revoke the privilege UNLIMITED TABLESPACE from a role you will get the error:
revoke unlimited tablespace from dba
ERROR at line 1:
ORA-01952: system privileges not granted to 'DBA'
It is as if the privilege UNLIMITED TABLESPACE was not granted to any role, however you can verify that some roles have this privilege by running the following query:
For this issue to exist in 126.96.36.199, this query needs to return one or more rows.
You recently upgraded this database from a previous release. This issue is not expected to affect newly created 188.8.131.52 databases.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms