how to grant select a table in a stored procedure scope

[charles candy]

Hi,

how to grant select to a table to a user only with in a stored procedure scope


I have grant execute on a pocedure to a user . but when I try execute , I get error select denied .

I do not wish to grant select table to the user cause if i do that then the user will be able to select the table records without need to call stored procedure.

this will cause security issue . any suggestion ?



Edited 1 time(s). Last edit at 08/18/2012 06:59AM by charles candy.