| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Find Queries by a group of users
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 <ORACLE-L_at_fatcity.com>
til cc:
<joni_65_at_yaho Subject: Find Queries by a group of users
o.com>
Sent by:
root_at_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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: joni_65_at_yahoo.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Oct 24 2002 - 16:26:20 CDT
(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: Rajesh.Rao_at_jpmchase.com 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: ListGuru_at_fatcity.com (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).
 |
 |