My Oracle Support Banner

Revoke Unlimited Tablespace From a role Raise ORA-01952 in version (Doc ID 1596639.1)

Last updated on OCTOBER 10, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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:

SQL> revoke unlimited tablespace from dba;
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, 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 databases.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.