/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

15 votes155 views5 answers
If null mysql
SQL
0 vote171 views1 answer
Php select data from mysql database without column name
SQL
0 vote155 views1 answer
Get all employees if name ends with in sql
SQL
0 vote119 views0 answer
SQL
0 vote157 views1 answer
Check duplicate values plsql
SQL
0 vote164 views1 answer
Vbscript clean up ADODB.Recordset
SQL
-1 vote151 views1 answer
Sql add column bit
SQL
0 vote150 views1 answer
Access refused mysql xampp server
SQL
11 votes197 views2 answers
Having keyword sql
SQL
0 vote147 views1 answer
Parsing float to int in mysql
SQL