/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

0 vote275 views1 answer
Query params sql insert python f string
SQL
0 vote293 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote266 views1 answer
Como hacer una consulta en sql
SQL
1 vote269 views1 answer
Mysql best tutorial for beginners
SQL
1 vote251 views3 answers
String to int mysql
SQL
1 vote251 views1 answer
Reutrn string after character sql
SQL
0 vote281 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote276 views2 answers
PostgreSQL having
SQL
0 vote270 views1 answer
Match end of string regex sql
SQL
11 votes263 views2 answers
Safe mode off mysql
SQL