I want to revoke all column privileges.
SELECT * FROM information_schema.column_privileges where grantee='PUBLIC' and privilege_type='UPDATE';
I want to return empty of above sql.
I tried to revoke all table and database from postgres and public users,but nothing change. Like these sql commands;
REVOKE ALL PRIVILEGES ON SCHEMA information_schema FROM postgres;
REVOKE ALL PRIVILEGES ON SCHEMA information_schema FROM public;
revoke all privileges on table information_schema from public;
REVOKE ALL PRIVILEGES ON DATABASE "db_name" FROM public;