/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

2 votes361 views1 answer
Create mysql user on all hosts
SQL
1 vote313 views1 answer
Clear screen command in psql
SQL
1 vote312 views1 answer
Stop mysql server mac
SQL
0 vote324 views1 answer
Sql #region
SQL
0 vote316 views1 answer
Run postgresql dump to csv
SQL
9 votes340 views6 answers
Replace sql
SQL
25 votes327 views1 answer
Mysql grant all privileges to a user
SQL
7 votes330 views2 answers
Oracle foreign key reference table
SQL
1 vote332 views1 answer
Sql group by sum with condition
SQL
1 vote317 views1 answer
Get table which have specific columns in mysql
SQL