Re: Data change watch without triggers

stan wrote:

> On Tue, 24 Jun 2003 08:20:46 -0700, Daniel Morgan
> <damorgan_at_exxesolutions.com> wrote:
>
> >Billy Verreynne wrote:
> >
> >>
> >> Why not? Triggers are there to protect data integrity. What's the reason
> >> behind saying that user A is not allowed to "use" triggers? Besides, it is
> >> not the _user_ who is using the trigger, but the _database_.
> >>
> >
> >This is a homework assignment from a class. Nothing more!
>
> Its is not Homework.
> I need it really. Oracle Support say me, thay don't know the solve.
> A program has in Code Config check for A, if there are any changes it
> dosn't work.
> But i need to know, when table by A was changed.
>
> Stan
>
> >
> >--
> >Daniel Morgan
> >http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> >damorgan_at_x.washington.edu
> >(replace 'x' with a 'u' to reply)
> >
> >

Nonsense. The requirement to not use a trigger was either assigned by an instructor or is a case of self-abuse.

If the former you need to solve the problem yourself. If the later my response is part of the pain you have self-inflicted.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)