/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

1 vote153 views1 answer
Search for replace in mysql
SQL
6 votes183 views5 answers
Oracle list tablespaces
SQL
0 vote138 views1 answer
Remove binlog mysql
SQL
0 vote143 views1 answer
Postgres read table structure
SQL
8 votes180 views3 answers
Find table for column name in sql
SQL
0 vote146 views1 answer
Apache Derby: Create SQL Dump with data
SQL
5 votes144 views2 answers
Copy data from one database to another
SQL
1 vote158 views1 answer
Full sql mode
SQL
0 vote174 views1 answer
Check constraint is violated
SQL
38 votes228 views6 answers
Ubuntu install mysql client
SQL