Re: Obtain SQL Statement from audit

[V�lez]

Hi

 

The version is Oracle 8i, so

is there a way to retrieve the sql statement?

could the v$sql view or v$sqltext view be useful?

 

regards

 

Arup Nanda <[EMAIL PROTECTED]> wrote:

You haven't specified the Oracle version. If it's 9i, you could use Fine Grained Auditing (FGA) to get the exact SQLs.

 

Hope this helps.

 

Arup

----- Original Message -----

From: Mauricio V�lez

To: Multiple recipients of list ORACLE-L

Sent: Monday, December 29, 2003 1:39 PM

Subject: Obtain SQL Statement from audit

Hello everybody

 

I am auditing select statements on one table, so I put the initialization parameter audit_trail = DB and I query the dba_audit_trail and sys.aud$ views and  I can get information but I can't get the sql statement.

The question is how can I retrieve the sql statement used to select on my table?

 

Regards,

 

Mauricio V�lez

---

Do you Yahoo!?
Yahoo! Photos - Get your photo on the big screen in Times Square

---

Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003