-
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
-
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 !!
ELSE
things go on as usual ...
Think about it.
Regards,
Chiappa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|