/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

2 votes189 views1 answer
Mysql now format
SQL
0 vote196 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote154 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote153 views2 answers
T sql null or empty string
SQL
0 vote199 views2 answers
Insert data into multiple tables mysql
SQL
1 vote160 views1 answer
Sql server today minus n
SQL
0 vote174 views1 answer
Set root password mysql xampp
SQL
0 vote165 views1 answer
SQL Server date literal
SQL
0 vote158 views1 answer
Exectuer myssql .sql
SQL
4 votes165 views1 answer
Sql delete multiple conditions
SQL