Re: Feature request: permissions change history for auditing - Mailing list pgsql-hackers

From Glyn Astill
Subject Re: Feature request: permissions change history for auditing
Date
Msg-id 114000.9747.qm@web23605.mail.ird.yahoo.com
Whole thread Raw
In response to Feature request: permissions change history for auditing  (Thom Brown <thombrown@gmail.com>)
Responses Re: Feature request: permissions change history for auditing
List pgsql-hackers
--- On Mon, 30/11/09, Thom Brown <thombrown@gmail.com> wrote:

> As far as I am aware, there is no way to tell when a
> user/role was granted permissions or had permissions
> revoked, or who made these changes.  I'm wondering if
> it would be useful for security auditing to maintain a
> history of permissions changes only accessible to
> superusers?

I'd have thought you could keep track of this in the logs by setting log_statement >= ddl ?

I'm pretty sure this is a feature that's not wanted, but the ability to add triggers to these sorts of events would
surelymake more sense than a specific auditing capability. 





pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Feature request: permissions change history for auditing
Next
From: Joachim Wieland
Date:
Subject: Re: Listen / Notify - what to do when the queue is full