/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

17 votes246 views4 answers
Sort by mysql
SQL
3 votes249 views2 answers
Oracle privileges users
SQL
36 votes258 views3 answers
Add column in mysq
SQL
0 vote235 views2 answers
Sql query in dax power bi
SQL
14 votes241 views2 answers
Oracle export trigger ddl
SQL
2 votes233 views1 answer
Tsql copy table
SQL
0 vote252 views1 answer
Mysql cli output to a file
SQL
0 vote237 views1 answer
Alter owner in PostgreSQL
SQL
0 vote231 views1 answer
Drop all tables db2
SQL
8 votes223 views1 answer
Oracle add month
SQL