Johnson,
Auditing, atleast in 8i, wont help. Maybe, if its not an overhead, you
could have a logon trigger that enables tracing for those users.
Raj
Johnson
Poovathummoot To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
til cc:
<joni_65@yaho Subject: Find Queries by a group of users
o.com>
Sent by:
root@fatcity.
com
October 24,
2002 04:57 PM
Please
respond to
ORACLE-L
Hi all,
We were trying to find a way to get all queries by a
group of users of the database. Auditing the users
lets us know whether they ran a 'select' 'update' etc.
but not the full text of the query. This is in 8i.
9i seems to have a view called DBA_FGA_AUDIT_TRAIL
which has a SQL_TEXT column.
Please advice.
__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
