You don't. However the stored procedure doesn't have to be owned by the
executing user so you would typically grant your select,update etc rights to
an application account and then grant execute on those procedures to your
users. At least thats how I'd do it.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Sean" <sean_at_kewi.net> wrote in message
news:bc264b7c.0112171542.758d5c66_at_posting.google.com...
> Platform : Oracle 8.1.7
>
> How do you allow a LOB field to be passed out of a stored procedure
> without granting select privliges to the table from which it comes
> from?
>
> Thanks.
Received on Thu Dec 20 2001 - 04:06:53 CST
