/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 vote154 views1 answer
Mysql limit results to 10
SQL
0 vote149 views1 answer
Sql #region
SQL
0 vote156 views1 answer
Sqlite version check
SQL
1 vote142 views1 answer
Psql filed name alter
SQL
4 votes146 views2 answers
Sql offset
SQL
32 votes136 views6 answers
Insert select
SQL
1 vote148 views2 answers
Sql server concat string and int
SQL
0 vote146 views1 answer
Date on SQL
SQL
0 vote145 views1 answer
Creation d'un trigger sql
SQL
0 vote149 views1 answer
How to find top 3 salary in sql
SQL