Re: table wrapper through stored procedure

Create the table in one user and create the sp to access that table in the same user. Now create a second user. Grant EXECUTE of that stored procedure to the second user. They won't be able to access the table, but can access the SP.

HTH,
Brian

Carsten Broschek wrote:
>
> Hi!
>
> Is there a way to deny directly access for reading/writing
> a dedicated table, but to access same table through a
> stored procedure:
>
> allow: user -----> SP ----> TABLE
> deny : user -------------------^
>
> I want to handle some checkings via the stored procedure,
> so data should only changeable via SP. How do I have to
> define adequate grants?
>
> Thanks in advance,
>
> Carsten

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"