/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 vote270 views1 answer
Save single sql query result boolean spring boot
SQL
11 votes271 views2 answers
Sql rank
SQL
-1 vote293 views1 answer
Capitole toulouse
SQL
6 votes328 views2 answers
Mysql convert timestamp to date
SQL
1 vote304 views1 answer
Psql connect
SQL
4 votes280 views1 answer
Restart for pg_hba.conf file
SQL
0 vote299 views1 answer
Get id if is not equal in certain table
SQL
8 votes279 views1 answer
Insert a select statement into a table
SQL
1 vote284 views2 answers
Mysql current user
SQL
1 vote275 views1 answer
Mysql column start with string
SQL