![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
raviraj
Joined: 31 Aug 2011 Posts: 16 Country: India |
|
Auditing Select Statements |
|
Hi,
How to enable Auditing Select Statements. Which audit table contains this log?
Thanks
|
|
Wed Sep 14, 2011 3:31 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
raviraj
Joined: 31 Aug 2011 Posts: 16 Country: India |
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7850
|
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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.
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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 |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
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
|
|
|