/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 vote120 views1 answer
Mysql events not work
SQL
0 vote129 views1 answer
To_date sql
SQL
3 votes107 views2 answers
Postgres download
SQL
1 vote113 views1 answer
Get url of cpanel database hostname
SQL
0 vote115 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote114 views1 answer
Oracle string length
SQL
3 votes126 views2 answers
See mysql users ubuntu
SQL
0 vote119 views1 answer
Mysql cli output to a file
SQL
0 vote113 views1 answer
Postgres : ERROR: division by zero
SQL
1 vote75 views1 answer
Oracle boolean to varchar
SQL