How to revoke column privileges

330 views Asked by At

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;
0

There are 0 answers