/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 vote210 views1 answer
Sql tabelle erstellen
SQL
0 vote198 views1 answer
Case insensitive sql
SQL
2 votes226 views1 answer
Oracle Column Names of a table
SQL
0 vote203 views1 answer
Mysql case when null
SQL
5 votes214 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote193 views1 answer
Mysql date time string format python
SQL
0 vote205 views1 answer
For row in sql database python loop
SQL
0 vote193 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
3 votes188 views1 answer
Sql server check version
SQL
0 vote196 views2 answers
Mysql on update current_timestamp
SQL