Re: Auditing

From: <tedchyn_at_yahoo.com>
Date: 1998/12/13
Message-ID: <7515nc$a17$1@nnrp1.dejanews.com>#1/1

Have you tried use sqltrace facility for a particular session and this will tell you what sql and what table your select statement is working on.

Ted Chyn
In article <36739370.1211431_at_news.freiburg.toplink.de>, nospam_at_localhost wrote:
> Hello all,
>
> Today I tried to audit the select statements for a specified table
> with the following command:
> audit select on test.test;
> When I query the aud$ tables with the provided views then I
> can see that the auditing is enabled for the specified table.
> Is it possible to get more information about the select statements
> which the user has sent to the database. For us it is very interesting
> which select statement was sent to the database to query the tables.
>
> Thanks in advance,
> -Marco Koch
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Dec 13 1998 - 00:00:00 CST