/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

4 votes211 views1 answer
Describe table mysql
SQL
0 vote187 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote188 views1 answer
Oracle array
SQL
1 vote232 views2 answers
Limit sqlserver
SQL
14 votes183 views3 answers
Alter foreign key
SQL
1 vote213 views1 answer
Mysql select all and rename one
SQL
0 vote252 views1 answer
Sintaxis SELECT sql
SQL
0 vote245 views5 answers
Right join
SQL
0 vote189 views1 answer
Sqlite higher or equal
SQL
0 vote170 views2 answers
Mysql regexp match word
SQL