pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedaudit table containing Select statements submitted
2+ messages / 2 participants
[nested] [flat]
* audit table containing Select statements submitted
@ 2006-05-03 19:39 Hogan, James F. Jr. <JHogan@seton.org>
2006-05-04 07:29 ` Re: audit table containing Select statements submitted Manlio Perillo <manlio_perillo@libero.it>
0 siblings, 1 reply; 2+ messages in thread
From: Hogan, James F. Jr. @ 2006-05-03 19:39 UTC (permalink / raw)
To: pgsql-admin
Can anyone point me in a direction that may help me populate in real
time a table that holds?
Current_user
Timestamp
"The Select Statement Submitted by the User"
I would like to easily determine who viewed what and when they viewed
it.
I have considered the fact that the result from SELECT yesterday may be
different than the result set returned by the SAME SELECT statement
today, but when used in conjunction with the INSERT, UPDATE, DELETE
audit logging I have already created, the answers to who viewed, what
and when would be readily available.
I have been searching all morning and...
The only thing I find on logging of Select statements is that the
information can be held in the Log Files...if Logging is enabled.
As I am only interested in the statements presented against certain
tables...
Turning on logging gives me more than I need or care to look through.
I could write a script to parses the Log Files into a Database Table but
would prefer to avoid enabling the file logging of statements if
possible.
Thanks for any reference or help you may be able to provide.
Jim
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: audit table containing Select statements submitted
2006-05-03 19:39 audit table containing Select statements submitted Hogan, James F. Jr. <JHogan@seton.org>
@ 2006-05-04 07:29 ` Manlio Perillo <manlio_perillo@libero.it>
0 siblings, 0 replies; 2+ messages in thread
From: Manlio Perillo @ 2006-05-04 07:29 UTC (permalink / raw)
To: pgsql-admin
Hogan, James F. Jr. ha scritto:
> Can anyone point me in a direction that may help me populate in real
> time a table that holds?
>
> Current_user
> Timestamp
> "The Select Statement Submitted by the User"
>
> I would like to easily determine who viewed what and when they viewed
> it.
>
I think you can easly log who selected a table, but there is no way to
know whitch columns where selected.
I'll try to add this feature to pglog, thanks for the hint.
Regards Manlio Perillo
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-05-04 07:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-03 19:39 audit table containing Select statements submitted Hogan, James F. Jr. <JHogan@seton.org>
2006-05-04 07:29 ` Manlio Perillo <manlio_perillo@libero.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox