/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 vote160 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
3 votes150 views1 answer
Sql cast to integer
SQL
1 vote161 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote144 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote145 views1 answer
Search db for table name
SQL
6 votes141 views5 answers
Mysql get last insert id
SQL
0 vote146 views1 answer
Dapper run sql script with parameters
SQL
0 vote137 views2 answers
Start mysql server using docker
SQL
0 vote143 views1 answer
Sql server set complex constraints
SQL
0 vote146 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL