/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 vote59 views2 answers
Postgresql get last day of month
SQL
2 votes58 views2 answers
Sql query to list all tables in a database sql server
SQL
1 vote51 views1 answer
Mysql show long running queries
SQL
0 vote61 views1 answer
Mysql change timestamp on update
SQL
0 vote43 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote48 views1 answer
How change the field place in mysql
SQL
3 votes48 views2 answers
Oracle drop column
SQL
0 vote52 views1 answer
Postgres populate table from another table
SQL
0 vote47 views1 answer
Transalations from sql to Linq count and group by
SQL
-1 vote74 views1 answer
Sql vs nosql or mysql vs mongodb
SQL