revoking a tablespace quota from user

to revoke a tablespace quota from an oracle database user, you can use the command as follows:

 

ALTER USER DB_USER QUOTA 0 ON TABLESPACE_NAME;

 

where

DB_USER is the oracle database user.

TABLESPACE_NAME is the tablespace name that you want to revoke quota from.

 

Hope This Helps !   🙂