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 Johns

Find Queries by a group of users

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.