/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 votes185 views1 answer
Mysql id of inserted row
SQL
1 vote162 views1 answer
How to get mysql db size
SQL
0 vote160 views1 answer
Sql requete number pair
SQL
0 vote176 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote186 views2 answers
Identity syntax in sql
SQL
2 votes163 views2 answers
Postgresql date at timezone
SQL
0 vote183 views1 answer
Sql tablo sp
SQL
0 vote183 views1 answer
Sql server convert to guid
SQL
0 vote166 views1 answer
How to see password mysql vestacp
SQL
1 vote163 views1 answer
Select from describe sql
SQL