/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 vote367 views1 answer
SQL date part only of datetime
SQL
0 vote353 views1 answer
Mysql shell set time_zone
SQL
0 vote396 views1 answer
Select top values sql
SQL
2 votes368 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote396 views1 answer
Define a variable in mysql from select
SQL
11 votes365 views5 answers
Sql server reset identity
SQL
0 vote357 views1 answer
Sql server system messeges
SQL
0 vote374 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote356 views1 answer
Postgresql regular expression special characters
SQL
7 votes376 views5 answers
Sql remove spaces
SQL