/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 vote260 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote314 views1 answer
Insert into using contant values and source table columns with sql
SQL
3 votes280 views1 answer
Oracle list privileges
SQL
0 vote264 views1 answer
Sql add calculated column
SQL
0 vote265 views1 answer
Java sql connection
SQL
0 vote258 views1 answer
Access mysql database docker container shell
SQL
0 vote255 views1 answer
Login phpmyadmin without password
SQL
4 votes322 views4 answers
Check constraint in ms sql
SQL
6 votes262 views1 answer
Check Table Exists
SQL
0 vote250 views2 answers
Select limit ms sql
SQL