Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122

    Unanswered: sql to script to give all objects performing inserts to a certain table

    Does anybody have script to give all objects performing inserts to a certain table ? I would certainly appreciate help on this.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Auditing?

    Set:
    Code:
    AUDIT INSERT ON HR.EMPLOYEES;
    And then check out the AUD$ table.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122
    The table I am trying to find this information for is po.po_line_locations. I was hoping there would be some 'dba' tables that might contain that kind of info rather than resorting to audit because my request to turn auditing on would probably be denied.

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Aud$

    Users can audit their own tables, all you need is one of these privileges:
    SELECT ANY DICTIONARY or SELECT on SYS.AUD$ to look at the results.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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