Re: Stored procedures ignore grants

> I have found that I cannot compile a stored procedure which selects from
> another user's table if my grant on that table is role-based. I get an
> error "Table or view does not exist". If I am given an individual grant
 

> on the table, I have no problem.

We had the same problems with 7.0.16 and have not tried it yet under 7.1.3. Supposedly it has something to do with the fact that when you execute a stored procedure, you inherit the privileges of the user who created the procedure. They coded this to be explicitly granted privileges as opposed to those inherited by a role. We got around this since we have a dummy user ID which owns all of the tables and creates all of the packages. It is a bit of a pain for development though. Received on Fri Dec 23 1994 - 03:48:47 CET