How do I revoke (grant drop on any table) from a user?

Question

I have a user with privilege Drop on Any Table. I need to revoke that. They only should have drop privileges on their own tablespace.

My setup is three schemas, production, reporting and ETL transfers if that makes any difference.

Answer 1

Try

REVOKE DROP ANY TABLE FROM X