/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 vote317 views1 answer
Provera dupliranih konatakata
SQL
7 votes365 views5 answers
Max 3 salary in sql
SQL
0 vote345 views2 answers
Psql commande \gset
SQL
4 votes329 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote355 views3 answers
Fetlife
SQL
0 vote346 views5 answers
How to make trigger in phpmyadmin
SQL
9 votes347 views6 answers
Replace sql
SQL
3 votes359 views2 answers
@sqlresultsetmapping
SQL
4 votes365 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote352 views1 answer
Kill mysqld_safe process mariadb
SQL