/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 vote333 views2 answers
Extract weekday from date in sql
SQL
2 votes324 views3 answers
Current setting postgres timezone
SQL
0 vote340 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote350 views1 answer
Postgres see sequence current state
SQL
0 vote264 views1 answer
Mysql find foreign key references
SQL
3 votes307 views2 answers
Truncate all tables
SQL
25 votes308 views3 answers
Mysql command show tables
SQL
0 vote340 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote313 views1 answer
Access mysql database docker container shell
SQL
0 vote317 views2 answers
Android sqlite query join
SQL