/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

3 votes180 views3 answers
How to add month in update sql
SQL
0 vote274 views1 answer
Show mysql account privilleges
SQL
25 votes178 views3 answers
How to use a database to see tables mysql
SQL
0 vote188 views1 answer
Postgresql copy backup table
SQL
0 vote178 views1 answer
Sql create table with datetime automatically
SQL
9 votes199 views6 answers
Sql add column with default value
SQL
7 votes212 views1 answer
Oracle pagination query rownum
SQL
0 vote172 views1 answer
Go install mysql
SQL
0 vote179 views1 answer
Mssql now diff 90 day
SQL
0 vote241 views1 answer
Inner join distinct
SQL