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