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

Thread: Auditing SELECTS

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Dear Members
    Can I audit SELECTS? If so, what view do I query to find out if SELECT has been executed on a table?
    roukie-dba

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    Hi, 7th Aug 2001 21:12 hrs chennai

    As per your needs this link helps you in depth.

    http://oradb1.jinr.ru/oracle/srvr/se...SCN73/ch19.htm

    Coming to the Audit Views you read the bottom link which is interesting and explained how to Query with Audit views and tabulated the same as an example

    http://www.oracle.com/oramag/oracle/...tml?69dba.html

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Is there a suitable front-end tool then for me to generate reports from the audit trail??? Or any useful scripts out there? Please help!
    roukie-dba

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    Hi, 8th Aug 2001 13:59 hrs chennai

    Find this article interesting for your requirement.

    http://www.synapse.ie/oracle_audit_manager.htm

    This link of not use to your problem but for the sake of Knowledge===>the link you have to type to show proper page.

    http://malaysia.cnet.com/download/pc/swinfo/0,2000028720,20106571s,00.htm

    Cheers

    Padmam

    [Edited by padmam on 08-08-2001 at 04:50 AM]
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Re: solution

    Hi, 9th Aug 2001 15:04 hrs chennai

    How about this one

    http://www.relationalwizards.com/htm..._auditing.html

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  6. #6
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    PADMAN
    Thanks very much for this information, very much appreciated!!
    roukie-dba

Posting Permissions

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


Click Here to Expand Forum to Full Width