/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

20 votes209 views4 answers
How to find average in sql
SQL
8 votes199 views3 answers
Find table for column name in sql
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
0 vote166 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote186 views2 answers
How to see table associated with a schema in sql
SQL
0 vote170 views1 answer
Delete first row in sql
SQL
1 vote207 views1 answer
Sql where max date
SQL
0 vote190 views2 answers
What is the default password for sql server sa
SQL
3 votes214 views2 answers
Oracle drop column
SQL
0 vote180 views1 answer
Make parameters nullable in sql server
SQL