/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

12 votes280 views6 answers
Between in sql
SQL
2 votes303 views1 answer
Dbms transaction (psql)
SQL
23 votes277 views4 answers
Sql server substring
SQL
0 vote267 views1 answer
Sub query in linq
SQL
0 vote279 views1 answer
How to execute stored output to csv files
SQL
0 vote306 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
3 votes301 views5 answers
Duplicate table sql
SQL
0 vote275 views1 answer
Do postgresql
SQL
1 vote275 views1 answer
Order by oracle
SQL
0 vote286 views1 answer
Delete first row in sql
SQL