/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 vote304 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote336 views1 answer
Connect to mysql database ubuntu
SQL
1 vote307 views1 answer
Mysql is odd
SQL
1 vote332 views1 answer
T-sql find object by name
SQL
0 vote294 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote316 views1 answer
Database db connection string format
SQL
2 votes313 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
10 votes298 views4 answers
Join with multiple conditions sql
SQL
2 votes333 views2 answers
Postgres timestamp to datetime
SQL
4 votes285 views1 answer
Update table from another table oracle
SQL