SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Auditing Select Statements

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Auditing Select Statements
Author Message
raviraj



Joined: 31 Aug 2011
Posts: 16
Country: India

Post Auditing Select Statements Reply with quote
Hi,

How to enable Auditing Select Statements. Which audit table contains this log?

Thanks
Wed Sep 14, 2011 3:31 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Use System Audit menu to enable auditing of database and user activities. Depending on the database type, the function name differs. For example, for SQL Server, you would need to enable auditing of Schema Object Access, for Oracle, you would need to enable TABLE and some other functions, etc....
Wed Sep 14, 2011 10:17 am View user's profile Send private message
raviraj



Joined: 31 Aug 2011
Posts: 16
Country: India

Post Reply with quote
Hi,

1) In which report I can find the select statement auditing.
2) Which table stores this information.

Thanks
Thu Sep 15, 2011 3:46 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Quote:
1) In which report I can find the select statement auditing.

You can see them in a number of reports, for example in Text of SQL Queries report. But you need to turn System Auditing first.

Code:
2) Which table stores this information.

This depends on your database server type. Which database server are you auditing?
Thu Sep 15, 2011 1:21 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.