Re: Data change watch without triggers

If you just need user B to know when a change has been made to the table, then set up auditing on that table and let user B query the audit trail. Or, you can have user A post a message with Advanced Queueing that user B can consume and take appropriate action.

HTH,
Brian

stan wrote:
>
> I have two DB users.
> User A has the data and can change the data and is not allowed to use
> triggers.
> User B can access the data of user A and user B should monitor the
> data changes of user A, e.g. by a trigger.
>
> Somebady an idee how to solve this.
>
> Thanks
>
> Staszek

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"