Re: Newbie problem with privileges and packages

From: Tom Best <Tom.Best_at_bentley.com>
Date: Wed, 12 Jan 2000 16:35:23 -0500
Message-ID: <387CF39B.B86D583E@bentley.com>

I think you have to qualify the package with the owner's user name in front.

billmil_at_my-deja.com wrote:

> This seems like a basic problem pertaining to grants/privileges.
>
> I can not execute a package/stored procedure when I run it under a user
> with "CREATE SESSION" role and "EXECUTE" privilege to the package. The
> following message appears:
> > PLS-00201: identifier 'PKG_USERS.USER_GET_BY_EMAIL' must be declared
>
> The package runs fine when I run it under a DBA user ID.
>
> The Oracle error message manual suggests that problem stems from
> insufficient privileges. The user, however, has execute privilege on
> each package and delete, insert, select, and update privileges on each
> table.
>
> Any suggestions?
>
> thanks
>
> bill milbratz
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 12 2000 - 15:35:23 CST