/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 vote178 views2 answers
How to update the multiple rows in sql
SQL
0 vote200 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote299 views1 answer
The differnece between to values in sql
SQL
1 vote198 views1 answer
Mysql text to decimal
SQL
8 votes189 views1 answer
Sql remove leading spaces
SQL
0 vote168 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote201 views1 answer
Cannot pip install mysqlclient
SQL
0 vote175 views1 answer
Rabbitmq ui not working
SQL
1 vote149 views2 answers
Delete auto increment mysql
SQL
12 votes185 views4 answers
How to take database dump in postgresql
SQL