/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 vote128 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote179 views1 answer
Mysql could not fetch tables
SQL
1 vote139 views3 answers
Sql select only time from datetime
SQL
0 vote140 views1 answer
Kill thread
SQL
13 votes133 views2 answers
Sqlite rename column
SQL
0 vote182 views1 answer
Delete from table where length sql
SQL
0 vote147 views1 answer
Sql drop default
SQL
0 vote152 views1 answer
For row in sql database python loop
SQL
0 vote138 views1 answer
Oracle procedure chain step
SQL
0 vote139 views2 answers
Postgresql gset
SQL