/SQL/Postgresql check privileges on schema

Postgresql check privileges on schema

User privileges postgresql information_schema

GRANT SELECT ON ALL TABLES IN SCHEMA PUBLIC TO testuser2;

Source: stackoverflow.com

Postgresql check privileges on schema

WITH "names"("name") AS (
  SELECT n.nspname AS "name"
    FROM pg_catalog.pg_namespace n
      WHERE n.nspname !~ '^pg_'
        AND n.nspname <> 'information_schema'
) SELECT "name",
  pg_catalog.has_schema_privilege(current_user, "name", 'CREATE') AS "create",
  pg_catalog.has_schema_privilege(current_user, "name", 'USAGE') AS "usage"
    FROM "names";

Source: stackoverflow.com

Similar codes

1 vote353 views1 answer
Sysdate in sql
SQL
0 vote361 views1 answer
What is between keyword used for
SQL
1 vote323 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote358 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
2 votes349 views2 answers
Mysql show table column comments sql
SQL
1 vote365 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote327 views0 answer
SQL
4 votes381 views1 answer
List tables sqlite
SQL
4 votes438 views4 answers
Remove duplicate old value in mysql
SQL
8 votes366 views1 answer
Racle create auto increment column
SQL