Wednesday, November 27, 2013

How to revoke access to tables prior to postgres 9.0

SELECT 'REVOKE SELECT ON TABLE ' || relname || ' FROM some_user;' FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE nspname = 'public';

No comments:

Post a Comment