Re: [HACKERS] Login/logout - Utility Database

2005-06-18 Thread Andreas Pflug
Juan Pablo Espino wrote: I want to register in an audit table the date and time of the login/logout of a database user. I have been looking for some function in the code but I didn't find something like that. This is the kind of functionality I'd expect to go to the pg_system (or however it i

Re: [HACKERS] Login/logout

2005-06-18 Thread Juan Pablo Espino
Hi, thanks for the response. On 6/18/05, Rod Taylor <[EMAIL PROTECTED]> wrote: > On Sat, 2005-06-18 at 11:46 -0500, Juan Pablo Espino wrote: > > Thanks for the quick response. Yes I want to retrieve the > > login/logout info, but I want to insert this info in a table that I > > use as an audit ta

Re: [HACKERS] Login/logout

2005-06-18 Thread Rod Taylor
On Sat, 2005-06-18 at 11:46 -0500, Juan Pablo Espino wrote: > Thanks for the quick response. Yes I want to retrieve the > login/logout info, but I want to insert this info in a table that I > use as an audit table. Regards I suggest putting together a short script to scan the logs periodically an

Re: [HACKERS] Login/logout

2005-06-18 Thread Juan Pablo Espino
Thanks for the quick response. Yes I want to retrieve the login/logout info, but I want to insert this info in a table that I use as an audit table. Regards Juan P. Espino On 6/18/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Sat, Jun 18, 2005 at 11:11:31AM -0500, Juan Pablo Espino wrote: > >

Re: [HACKERS] Login/logout

2005-06-18 Thread Michael Fuhr
On Sat, Jun 18, 2005 at 11:11:31AM -0500, Juan Pablo Espino wrote: > > I want to register in an audit table the date and time of the > login/logout of a database user. I have been looking for some function > in the code but I didn't find something like that. Are you interested in logging to a tab

[HACKERS] Login/logout

2005-06-18 Thread Juan Pablo Espino
Hello all I want to register in an audit table the date and time of the login/logout of a database user. I have been looking for some function in the code but I didn't find something like that. Can you give me some ideas to implement it?. I'm ready to program if it is necessary. Thanks in advanc