table wrapper through stored procedure

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 Received on Wed Jun 18 2003 - 13:05:32 CDT