/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 vote287 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
11 votes280 views2 answers
Oracle saurce code
SQL
0 vote273 views1 answer
Time data type in mysql
SQL
0 vote253 views1 answer
Sql select rows with different values in one column
SQL
-1 vote255 views1 answer
Adding a new table psql
SQL
1 vote257 views1 answer
Drop df constraint sql server
SQL
0 vote284 views1 answer
Make parameters nullable in sql server
SQL
14 votes255 views3 answers
SQL trim
SQL
5 votes268 views4 answers
Mysql update column with value from another table
SQL
0 vote263 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL