SELECT 'TEMPORARY privilege to the database has been granted to PUBLIC' AS mistake
FROM pg_database
WHERE datname=current_database()
AND (array_to_string(datacl,',') IS NULL
OR array_to_string(datacl,',') ~ '^=.{0,1}[T].{0,1}/');
SQL statements that help generate fixes for the identified problem.
SQL Query to Generate Fix
Description
SELECT format('REVOKE TEMP ON DATABASE %1$I FROM PUBLIC;', current_database()) AS statements
FROM pg_database
WHERE datname=current_database()
AND (array_to_string(datacl,',') IS NULL
OR array_to_string(datacl,',') ~ '^=.{0,1}[T].{0,1}/');
Revoke the TEMPORARY privilege from PUBLIC.
Collections
This query belongs to the following collections:
Name
Description
Find problems automatically
Queries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not .
Categories
This query is classified under the following categories:
Name
Description
Security
Queries of this category provide information about the security measures.