From: | chris <chrisk(at)pgsqlrocket(dot)com> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | audit table with permissions |
Date: | 2018-02-28 21:12:34 |
Message-ID: | fa4dc973-83be-db37-44c3-d197c3908fbb@pgsqlrocket.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I created functions and a trigger to audit tables on my database but I
have a problem with permissions on the functions and function schema I
created. I can grant permissions to the current user of the original
table being audited but I need a way to automate grants and revokes made
to the original table so that any time those change in the future I
don't have to worry about updating permissions or leaving a hole in
security by granting all users full permissions to the functions and
function schema.
From my understanding event triggers can't be set the grant/revoke only
create, alter or drop.
Any input would really help me, I'm very fresh to writing functions and
triggers.
Thanks,
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Alexandre Garcia | 2018-02-28 21:12:58 | Re: postgresql 9.6 - cannot freeze committed xmax |
Previous Message | MichaelDBA | 2018-02-28 21:04:11 | Re: Postgresql | Vacuum information |