Ora-01950: no permission for table space xxx

Previously, grant DBA to user was executed.

I checked one of the DBA roles:

DBA unlimited tablespace Yes

Now the revoke DBA from user is executed

Error: ora-01950: no permission for table space xxx

Method:

Alter User Username quota umlimited on tablespacename;

Or Grant resource to username.

Because grant resource to username automatically obtains the system permission of unlimited tablespace.

Find this line from online documents:

When you grant the DBA and resource roles to a user or role with oracle7 release 7.2.2 or later, the user or role is also granted the unlimited tablespace system privilege. when you revoke either role from a user or role, the unlimited tablespace system privilege is also revoked. the unlimited tablespace can also be revoked independent of the DBA and resource roles.

Thanks:

S7323522