/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

4 votes277 views1 answer
Restart for pg_hba.conf file
SQL
-1 vote302 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote288 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote345 views1 answer
Hierarchal database table
SQL
2 votes295 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
3 votes300 views1 answer
Start mysql server by terminal in linux
SQL
0 vote233 views1 answer
Sqlalchemy filter relationship
SQL
31 votes286 views4 answers
How to get duplicate records with multiple field in sql
SQL
12 votes289 views4 answers
Import mysql database command line linux
SQL
1 vote300 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL