audit table with permissions
| От | chris |
|---|---|
| Тема | audit table with permissions |
| Дата | |
| Msg-id | fa4dc973-83be-db37-44c3-d197c3908fbb@pgsqlrocket.com обсуждение исходный текст |
| Ответы |
Re: audit table with permissions
|
| Список | 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
В списке pgsql-admin по дате отправления: