Re: Newbie problem with privileges and packages

If USER1 owns the package, then USER2 must invoke it like this:

   USER1.PKG_USERS.USER_GET_BY_EMAIL Or you can create a synonym:

  CREATE SYNONYM PKG_USERS.USER_GET_BY_EMAIL FOR USER1.PKG_USERS.USER_GET_BY_EMAIL; Then USER2 can invoke the procedure like you did:

  PKG_USERS.USER_GET_BY_EMAIL <billmil_at_my-deja.com> wrote in message news:85igdt$c7p$1_at_nnrp1.deja.com...
> 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 Thu Jan 13 2000 - 00:22:45 CST