/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 vote211 views1 answer
Mysql workbench format date
SQL
0 vote188 views1 answer
Increment id in mysql
SQL
0 vote216 views1 answer
Laravel migration sql dump
SQL
1 vote194 views1 answer
Sql try catch
SQL
1 vote210 views1 answer
Raw query must include primary key
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote191 views2 answers
Azure sql-datenbank
SQL
-2 votes206 views1 answer
Mysql not empty
SQL
1 vote206 views1 answer
Sqlite update from another table
SQL
1 vote200 views1 answer
Mysql dump specific tables
SQL