/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

7 votes141 views5 answers
Sql remove spaces
SQL
10 votes163 views2 answers
Reset mysql root password mac
SQL
0 vote151 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote139 views1 answer
How to print some string in mysql
SQL
2 votes163 views1 answer
Sql server: select column values as comma separated string
SQL
4 votes151 views2 answers
Tables in sql
SQL
5 votes144 views1 answer
Oracle asynchronous update
SQL
1 vote140 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
8 votes205 views1 answer
Oracle search code in packages
SQL
0 vote156 views1 answer
Mysql dump with table query
SQL