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 !   🙂