Database Auditing

Hi,

Is it possible to turn Auditing for the current session and whenthe user logsoff from SQL*PLUS it should be turned off.

Any help will be appreciated.

Thanks.
Vijay.

For auditing purpose , you can use sql_trace which can be turned on/off by session wise

Hi Vijay,

You could create a trigger logon that enable audit for this user and a trigger looff for disable auditing.

Cheers

Angel