Postgresql: how to revoke grant option from role?

Question

I have postgresql 15 db. There I have different roles based on which users are created.

What I need is to revoke grant option for roles. In my company we need to do it via different system.

I tried:

REVOKE GRANT OPTION FOR ALL ON SCHEMA schema_name FROM role_name;

but it does not work.

What do I need to do to revoke grant option from roles?

Answer 1

Ensure you have sufficient privileges (most preferably superuser) to run the REVOKE command then try REVOKE <the_privilege or ALL> ON ALL TABLES IN SCHEMA <schema_name> FROM <role_name> CASCADE;

You can also consult the Postgres docs on REVOKE to get more information on the REVOKE command.