/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 vote285 views1 answer
Mysl like insert a variable
SQL
0 vote179 views1 answer
Check if due date is less than todays date sql
SQL
0 vote224 views1 answer
Sql not exists
SQL
0 vote228 views1 answer
Sql create table with references not primary key
SQL
0 vote236 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote228 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote256 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote216 views1 answer
Connect postgresql using a connection string
SQL
3 votes214 views1 answer
Oracle nextval
SQL
1 vote301 views1 answer
Mysql get max value and id
SQL