Search Postgresql Archives

Re: DB Audit

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



misspaola@xxxxxxxxxx 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux