/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 vote201 views1 answer
Delete double on SQL with multiple primary keys
SQL
4 votes198 views1 answer
SQL order random
SQL
0 vote233 views1 answer
No suitable driver found for sqlite
SQL
0 vote226 views1 answer
Duplix print in Smartforms
SQL
0 vote220 views1 answer
Sql server size of every table in a db
SQL
2 votes203 views1 answer
Sql find missing values between two tables
SQL
0 vote230 views1 answer
PSQL qith variables
SQL
4 votes194 views3 answers
Create database in mySQL
SQL
0 vote232 views1 answer
Mysql get hour from datetime
SQL
0 vote244 views1 answer
Sql server datetime
SQL