Hi,
Does the new user has synonyms to the SPs ?
The DAD with which the new user is logging on, is that the same as the
1st user ? If not, is the spec of the DAD right i.o. the tablespace
definition and the db ?
Some 1st wild ideas, maybe are some help ...
gr, Peter
Aaron Sayer wrote:
>
> Re: Novice Multi-User Help message
>
> Hi out there,
>
> We are using Oracle Web Server and have created procedures in a created
> tablespace. Now we want to add another user that can access the
> procedures/tables from the Web using the Oracle Web Server listener.
>
> Our problem is trying to access SP's when logging on the Web as a user other
> than the user who created the SP even though the logged on user has full
> execute access. At present we are getting around this problem by creating
> the same SP against the second user but this seems unnecessary.
>
> Can you help us on this one??
>
> Thanks in advance.
>
> Stewart
Received on Wed Feb 03 1999 - 06:11:09 CST
