Re: Difference error message in difference user?

I found that when I through Oracle ODBC Driver(8.01.06.00) to access Oracle by ASP, I receive this error:

    "[Oracle][ODBC][Ora]ORA-04043: Object ... does not exist" I found that the error acutally raised by a data redundancy. If I use Miscosoft ODBC for Oracle(2.573.4202.00), the error message will be correct and very clear.

postbus_at_sybrandb.demon.nl wrote:

> Please post the *exact* error message and the source of the procedure in error.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> In article <3A890170.9BD26C2E_at_hknet.com>, Diviner says...
> >
> >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 Wed Feb 14 2001 - 22:42:43 CST