Re: Logging queries in oracle 8.1.7

Look at auditing in the docs.
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"sachin" <sachin_mahajan_at_hotmail.com> wrote in message
news:2317671a.0301021126.3d842f82_at_posting.google.com...


> Hi Gurus:

>

> Is there any convenient way to log queries in oracle (preferably

> triggers)? I have a table which has changeby, changedate and

> primarykey. whenever a user accesses that i want to stick in that row

> accessed (changeby, changedate and primarykey) into another table. If

> the user is inserting updating or deleting i can easily log it using

> triggers.

>

> Thanks,

> Sachin