Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: Need help with dynamic SQL in trigger

    Hi Oracle gurus,

    I am trying to create a trigger that fires after a user logon and logoff and does the following:

    creates a new user
    deletes data from old temp table

    Then I need to create a package that executes dynamically to
    drop old users
    remove the old user account access

    We are running Oracle 8i/9iR2 on UNIX.
    Since I am new to PL/SQL programming and Oracle could anyone help point me in the right direction? Can I write dynamic SQL in a trigger or package to do these things?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What problem are you really trying to solve?
    On the surface the "design" sounds to be a total kludge.
    >I am trying to create a trigger that fires after a user logon and logoff and does the following:
    You need to make up your/our mind. LOGON<>LOGOFF
    Fire for every USER which that does logon & logoff?
    >creates a new user
    Random name & password? WHY?
    >Then I need to create a package that executes dynamically to drop old users
    WHY?
    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
    May 2003
    Posts
    369

    logon trigger to detect changes to database

    Actually what I need is to create a trigger to detect changes made by a user account after the user logs into the database and makes changes against the database. Sorry for the confusion. More of an auditing tool to track DDL changes made by a user.

    Thanks

    B

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >More of an auditing tool to track DDL changes made by a user.
    Whats wrong with just using AUDIT?
    http://download-west.oracle.com/docs...8a.htm#2059074
    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.

Posting Permissions

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