Re: Newbie problem with privileges and packages

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