/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 vote107 views1 answer
Oracle query to find schema you are working on
SQL
0 vote99 views1 answer
Insert into using contant values and source table columns with sql
SQL
3 votes93 views1 answer
Set default today mysql
SQL
2 votes99 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote107 views1 answer
Shell script to log mysql cpu usage
SQL
49 votes188 views6 answers
Install mysql ubuntu
SQL
1 vote89 views1 answer
Real world example of nosql
SQL
0 vote104 views1 answer
Sql select with apostrohpe
SQL
0 vote103 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote100 views1 answer
Big table in mysql
SQL