Audit a User Only When he login to SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Audit a User Only When he login to SQL

  1. #1
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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

  3. #3
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    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.

  4. #4
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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
  •  



Click Here to Expand Forum to Full Width