Tips and experience about developing websites with various technologies
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