/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 votes136 views1 answer
Postgresql create schema in specific database
SQL
0 vote121 views1 answer
Sql server select furst day of current year
SQL
1 vote124 views1 answer
Mysql check table exists
SQL
0 vote129 views1 answer
SQL isnumeric DB2
SQL
2 votes124 views1 answer
How to check if a row is null in sql
SQL
0 vote150 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
2 votes133 views1 answer
Sql find not in list
SQL
0 vote222 views1 answer
Running mysql from bash sc
SQL
2 votes121 views1 answer
Install sqlite npm
SQL
4 votes135 views1 answer
W3schools create table
SQL