Re: Logging queries in oracle 8.1.7
From: Darren <darren.cuthere_at_mallette.cut_cut_cut.com>
Date: Fri, 03 Jan 2003 18:44:22 GMT
Message-ID: <aSkR9.141414$E_.30663_at_news02.bloor.is.net.cable.rogers.com>
Date: Fri, 03 Jan 2003 18:44:22 GMT
Message-ID: <aSkR9.141414$E_.30663_at_news02.bloor.is.net.cable.rogers.com>
look at auditing schema objects ie
audit select on table_name;
"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
Received on Fri Jan 03 2003 - 19:44:22 CET