| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
| Cc: | Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, MauMau <maumau307(at)gmail(dot)com>, Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Ian Barwick <ian(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgaudit - an auditing extension for PostgreSQL |
| Date: | 2014-12-27 08:08:32 |
| Message-ID: | CA+U5nMLbyTbGk_y02+_w8bryCH5dobe-VaMte=XdFj+RSiJ+4w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 25 December 2014 at 17:09, Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:
> On Thu, Dec 25, 2014 at 5:42 AM, Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com> wrote:
>>
>> To summarise for people who haven't followed the thread in detail, the
>> idea is that you would do:
>>
>> grant select on foo to audit;
>>
>> ...and the server would audit-log any "select ... from foo ..." queries (by
>> any user).
>
> what if i want to audit different things for different users?
That is supported - you can provide a list of roles to be audit roles.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2014-12-27 08:09:26 | Re: CATUPDATE confusion? |
| Previous Message | Merlin Moncure | 2014-12-27 05:56:18 | Re: BUG #12330: ACID is broken for unique constraints |