Re: Difference error message in difference user?

From: L120bj <l120bj_at_aol.com>
Date: 13 Feb 2001 09:25:36 GMT
Message-ID: <20010213042536.02875.00000910@ng-fy1.aol.com>

>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:25:36 CST