/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

12 votes358 views4 answers
How to check mysql version ubuntu
SQL
12 votes315 views3 answers
Duplicate a column in sql
SQL
0 vote293 views1 answer
Connection error in mysql workbench
SQL
0 vote327 views2 answers
Transaction php
SQL
0 vote360 views1 answer
Oracle string length
SQL
0 vote369 views1 answer
Postgres list tables and row counts
SQL
1 vote376 views1 answer
Mysql update inner
SQL
0 vote314 views1 answer
Mysql select where text contains
SQL
0 vote313 views1 answer
Oracle select invalid views
SQL
0 vote518 views1 answer
Sql change a colum to unique
SQL