Re: Difference error message in difference user?

I have already granted execute privilege to that user. If the Data is accepted by database, the user can work on the procedure normally. The problem just raised while the data is not well prepared(like redundancy), the error message alwasy gives "Can't find this object...". Obviously, this is not the really intrinsic error. May be the user still "no privilege to obtains the real error"?

> >Subject: Difference error message in difference user?
> >From: Diviner diviner_at_hknet.com
> >Date: 2/13/01 8:43 AM GMT Standard Time
> >Message-id: <3A88F3A3.929F52C0_at_hknet.com>
> >
> >Why I can't get a suitable error message when I am login as
> >a normal user? It always return: "Can't find this procedure" even
> >the error was raised by a record duplicated violation. But if I
> >do the same things by the object owner, the properly error
> >message can be seen.
> >
> >Isn't it I forgot to grant some privilege to this user?
> >
> >--
> >Best regards,
> >Diviner.
>
> Hi Diviner,
> You need to grant execute on the procedure to the 'normal user' and also
> create a synonym, either private or public, to point the user to the object in
> the master schema.
> Regards,
> Rob
Received on Tue Feb 13 2001 - 03:42:08 CST