DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Trigger to record unsuccessful logins

  1. 03-04-2008, 12:34 AM #1
    zam
    zam is offline Junior Member
    Join Date
    Jun 2007
    Posts
    60

    Post Trigger to record unsuccessful logins

    Hi

    I need to record userids and time of all unsuccessful logins to database. I don't think I can do it with auditing options correct me if I am wrong.
    I thought of before login trigger but still unsure where to get information from

    Thanks
    Reply With Quote Reply With Quote
  2. 03-04-2008, 01:00 AM #2
    zam
    zam is offline Junior Member
    Join Date
    Jun 2007
    Posts
    60
    I think I need to correct myself I have just read in docs that database cannot have before logon trigger so then I how can I get the above info
    Thanks
    Reply With Quote Reply With Quote
  3. 03-04-2008, 01:46 AM #3
    bhattnirav
    bhattnirav is offline Member
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Metalink Doc id : 352389.1 is useful to you.
    Reply With Quote Reply With Quote
  4. 03-04-2008, 01:49 AM #4
    zam
    zam is offline Junior Member
    Join Date
    Jun 2007
    Posts
    60
    Thank you. It worked.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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