Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] user-based query white list - Mailing list pgsql-hackers

From Euler Taveira
Subject Re: [HACKERS] user-based query white list
Date
Msg-id CAHE3wgg7s_Z7Tg9UM+s2sACL75AMQVwA17qg1z6bwtmenf_kSw@mail.gmail.com
Whole thread Raw
In response to [HACKERS] user-based query white list  (Tim Burgan <timburgan@gmail.com>)
List pgsql-hackers
Tree view
2017-07-03 3:11 GMT-03:00 Tim Burgan <timburgan@gmail.com>:

Since then, is it now possible to configure a user to only be able to execute a limited white-listing of queries? Is this something that could now be implemented through extensions?

Since pg_stat_statements infrastructure, it is possible to create extensions that prohibit query execution for certain users (see sql_firewall [1] as an example).


[1] https://github.com/uptimejp/sql_firewall


--
   Euler Taveira                                   Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] WIP patch for avoiding duplicate initdb runs during"make check"
Next
From: Heikki Linnakangas
Date:
Subject: Re: [HACKERS] AdvanceXLInsertBuffer vs. WAL segment compressibility