Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Question Unanswered: user's log problem

    i have executed this code and now i want to store the information in a table that which user have tried to access the database other than office timings and what was the time when any user tried to access the database. i.e., a table must be created having two(2) columns named access_time & user_name, in which user's name & access time will be stored.

    create or replace trigger secure_emp
    before
    insert or update or delete
    on emp
    begin
    if (to_char(sysdate,'HH24MI') not between '0800' and '1700') then
    raise_application_error(-20500,'You may only insert,update or delete during office timings');
    end if;
    end;

    Regards
    Ismat

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >now i want to store the information in a table
    Good for you.
    So what is stopping you from doing this?
    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
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    I will give you a hint.

    1) standalone procedure
    2) AUTONOMOUS_TRANSACTION

    Do some searching on asktom.oracle.com

    and anacedent, LOL.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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