/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

10 votes132 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote128 views1 answer
Stored procedure function relation
SQL
1 vote120 views1 answer
Sql find column name like
SQL
6 votes110 views1 answer
Phpmyadmin password root
SQL
19 votes107 views6 answers
Laravel sql query
SQL
0 vote119 views1 answer
Create schema sql server
SQL
0 vote125 views1 answer
Mysql in clausule string array
SQL
0 vote117 views2 answers
Oracle create tablespace autoextend
SQL
-1 vote106 views1 answer
Sql syntax create timestamp column
SQL
4 votes129 views6 answers
List all tables in postgres
SQL