/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 vote187 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote151 views1 answer
What is default mysql database password in linux
SQL
5 votes136 views1 answer
Commentaire table oracle
SQL
0 vote117 views1 answer
The local psql command could not be located
SQL
0 vote153 views1 answer
Time data type in mysql
SQL
0 vote133 views1 answer
Narural join
SQL
0 vote137 views1 answer
Java nosql sort
SQL
0 vote126 views1 answer
Python sqlalchemy orm to select null values
SQL
1 vote131 views1 answer
Select random sample sql
SQL
0 vote130 views2 answers
Demmarrer un service mysql teminal cmd
SQL