Re: Insufficient Privileges - ORA-01031 - HELP PLEASE!!!!!

Hi Andy!
Yes it does work if I am connected as the schema's owner but it does not work as another user even if I prefix tables with the schema name. Thanks for your help.
Lesley.

"Andreas Stephan" <andreas.stephan.as_at_bayer-ag.de> wrote in message news:9f03oo$4tj2_at_byz672.bayer-ag.com...
> Hi Lesley,
>
> please give me more information about the users and/or schemas you used in
> sqlplus and forms.
> Does the trigger work if you connect as the schema owner?
>
> Regards Andy
>
> Lesley Boughner <lesley_at_vimich.com> schrieb in im Newsbeitrag:
> 9ettq202h5k_at_enews4.newsguy.com...
> > Please Help Me!!!!
> > This error is occurring in my pre-delete trigger of the master block
 when
 I
> > attempt to delete a record under certain usernames.
> >
> > On the tables it's attempting to delete from I have granted insert,
 update
> > and delete privileges.
> >
> > I can actually delete these records from SQLPLUS under the usernames it
> > gives me this error with in Forms.
> >
> > In relationship in forms - delete record property is set to cascading.
> >
> > Does anyone know what the problem may be?Thanks for any input.
> > Lesley
> >
> > This is my pre-delete trigger:
> >
> > BEGIN
> >
> > DELETE FROM DISPATCHLINES D
> > WHERE D.DISPATCHID = :DISPATCH.DISPATCHID;
> >
> > DELETE FROM DISPATCHACTIVITY D
> > WHERE D.DISPATCHID = :DISPATCH.DISPATCHID;
> >
> > IF NOT FORM_SUCCESS THEN
> > MESSAGE ('Internal error occurred in DISPATCH.PRE-DELETE TRIGGER.');
> > RAISE FORM_TRIGGER_FAILURE;
> > END IF;
> > END;
> >
> >
> >
> >
>
>
Received on Sat Jul 21 2001 - 23:46:46 CEST