Paweł Domański
8 lines
235 B
SQL
8 lines
235 B
SQL
SELECT 'REVOKE ALL PRIVILEGES FROM TABLE public."' || relname || '" FROM <some_user>;'
|
|
FROM pg_class
|
|
WHERE relname NOT LIKE 'pg_%' AND
|
|
relname NOT LIKE 'information%' AND
|
|
relname NOT LIKE 'sql_%' AND
|
|
relkind = 'r'
|
|
ORDER BY relname;
|