Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2003
    Posts
    65

    Unanswered: How do I create a Audit Trigger on 8i

    Hi,

    I was wondering what a trigger would like if I wanted to create one that kicked off when a user connected to the database. I wanted it to maybe disconnect the user if it did not match certain criteria.
    Any examples would be appreciated.

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    65
    Maybe I should better phrase my question. I wanted to know how I can create a simple logn_on and log_off trigger. Basically storing the info when a user logged on and when a user logs off. I know some of the basic info that I can grab.

  4. #4
    Join Date
    Oct 2004
    Posts
    145
    How about relying on oracle's auditing functions by turning it on?

  5. #5
    Join Date
    Nov 2003
    Posts
    65
    Quote Originally Posted by JimYoo
    How about relying on oracle's auditing functions by turning it on?
    That would be great if I had admin rights to that particular DB. I wanted to create one for my own sanity as a user.

  6. #6
    Join Date
    Nov 2003
    Posts
    65
    Quote Originally Posted by JimYoo
    How about relying on oracle's auditing functions by turning it on?
    That would be great if I had admin rights to that particular DB. I wanted to create one for my own sanity as a user.

  7. #7
    Join Date
    Oct 2004
    Posts
    145
    hum...

    You would have to have access to system tables to determine if user logged and out. I am not sure without this access how you would determine who logged in and out.

    IF for whatever reason, auditing is required, talk to personnel with appropriate rights and request access to audit tables. I will save you lot of grief. Else, attempt to capture the login from the application side?

  8. #8
    Join Date
    Nov 2003
    Posts
    65
    You are right ... i would need some access to the sys tables. This enters in the realm of being a dba ... something i look forward to becoming some day but atm ... im a developer with user access trying to think of something for the dba's to implement.

    Thanks for the info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •