Newbie problem with privileges and packages

From: <billmil_at_my-deja.com>
Date: Wed, 12 Jan 2000 18:16:44 GMT
Message-ID: <85igdt$c7p$1@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 Wed Jan 12 2000 - 12:16:44 CST