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
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
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.
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 !!
things go on as usual ...
Think about it.
Click Here to Expand Forum to Full Width