Auditing Select Statements

Hi,

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

Thanks

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....

Hi,

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

Thanks

	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?