| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "misspaola(at)tiscali(dot)it *EXTERN*" <misspaola(at)tiscali(dot)it>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DB Audit |
| Date: | 2013-12-10 15:21:08 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C7E142@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
misspaola(at)tiscali(dot)it wrote:
> I am using sybase ase as dbms and I would migrate to postgresql, but the absence of a built in DB
> audit functionality is a show stopper for me.
>
> So I would know if there is a way to get information about DB events like:
>
> server boots
>
> login & logout
>
> table access.
>
> attempt to access particular objects
>
> particular user’s actions.
You can use the server log file to record all these events.
You won't be able to define logging for only certain tables,
but it is possible to discriminate based on database or
logged on user.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2013-12-10 15:33:49 | Re: Return setof values from C-function |
| Previous Message | Merlin Moncure | 2013-12-10 15:03:42 | Re: add parameter to existing function |