Audit a User Only When he login to SQL

[SAJI]

hi,

I am trying to audit a user only when he login to SQL promt . When i give audit session by user, it audit whenever the user login to the application also.

I want to audit only when he login to sql prompt not when he login through the front end application.

looking an urgnet help

[pando]

what do you mean sql prompt... sql*plus? if so just write a logon trigger whenever he logons check the module from v$session if it's S.Q.L.P.L.U.S insert to your audit table

[SAJI]

Sql Prompt i mean SQL Plus.
The user is having the access through front end, and i dont need to audit that. only when he logged in sql plus , i need to audit that user.

[JChiappa]

Just a reminder : nowadays there is a ** LOT ** of tools capable to offer SQL connections against Oracle databaases , like : TOAD, MS-Query, and many more freewares available in the Net. So, I don´t know if its´safe to code like :


IF program-in-v$session='sqlplus' then
YOU ARE CATCHED !!
ELSE
things go on as usual ...


Think about it.


Regards,

Chiappa