Techspot - Databases, web, servers - Philip Wu
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';
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)