Re: SQL Scripts

You could try using Oracle Audit. Most people (including me, in the past) keep away from this because it has the rep. of slowing everything down - but I suspect this is because people switch everything on. You can be quite specific.

Have a look at the manual on this to see if it would give you what you need. (Novel suggestion of the week: read the manual<g>)

Len

>Hi Gurus and happy new Year !!!
>
>Some people hear has to Test some applications and I'd like to Audit the
>inserts/Updates that they will make inserting some data in a Table.
>I need to populate a Table with:
> test_date
> user_id
> Name of Form
> Db_Table
> Column_of_Table
> Date Inserted
>
>My question is : How can I take the User_id, the Name of Form, Db_Table
>and
>Column_of_Table ???
>My idea is tu use a Trigger for all the tables
>
>Any ideas???? Thanks !!!
>
>
Received on Sun Jan 03 1999 - 00:00:00 CET