Files
DBAdmin/inbox/DataBase/PostgreSQL/queries/tables_with_no_public_grants.sql
2026-05-18 06:40:19 +00:00

6 lines
175 B
SQL

SELECT relname, array_to_string(ARRAY[relacl], '|') as permits
FROM pg_class
WHERE relkind = 'r'
AND position('|=' in array_to_string(ARRAY[relacl], '|')) = 0
ORDER BY 1;