/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

0 vote193 views1 answer
Hive batch drop table
SQL
0 vote210 views1 answer
Oracle execute immediate quotes
SQL
0 vote202 views1 answer
Count columns psql(PostreSQL)
SQL
1 vote204 views1 answer
How to set up a trigger in sql
SQL
0 vote207 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote199 views1 answer
Change magento database url usimg musql
SQL
0 vote263 views1 answer
Compare two tables to find unmatched records
SQL
2 votes183 views2 answers
How to check database username and password in postgresql
SQL
0 vote202 views1 answer
Closure in sql
SQL
1 vote199 views2 answers
How to enable error squiggles in vs code
SQL