/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 vote226 views1 answer
Mysql select inside sum
SQL
1 vote241 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote239 views1 answer
Group by max date
SQL
0 vote227 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote236 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
2 votes257 views1 answer
Select a certain number of entries from select mysql
SQL
1 vote250 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote226 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote234 views1 answer
Find usage of table in sql server
SQL
0 vote229 views1 answer
Xampp increame mysql speed
SQL