Re: wierd pl/sql

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 5 Jan 2000 11:43:25 +0100
Message-ID: <84v78j$aqi$1@news3.isdnet.net>

The role grants the access to the table at the sql prompt but not in a procedure. To access the table in a procedure the user must have the select privilege directly and not via a role.

--
Have a nice day
Michel

Nick <nick_j_at_mailcity.com> a écrit dans le message : 38729DF0.9C9C1E5A_at_mailcity.com...
> Hi,
>
> We are selecting data from websys.ows_content from the sql prompt, and
> getting results back. But if we put the _same_ select statement in a
> procedure, we encounter "PLS-00904: insufficient privilege to access
> object WEBSYS.OWS_CONTENT"
>
> We have successfully added the privleges for the user
> (OWS_STANDARD_ROLE).
>
> Thanks for any help.
>
> Regards,
>
> Nick.
>
>
>
Received on Wed Jan 05 2000 - 04:43:25 CST