SqlUser-529296
SSCarpal Tunnel
Points: 4072
More actions
January 24, 2008 at 5:07 am
#186054
Hi All,
Is it possible to lock the particular stored procedure/Function in sql server?
Piotr.Rodak
SSCrazy Eights
Points: 9376
January 24, 2008 at 6:01 am
#771228
as in deny everyone from executing it? this is from BOL, DENY statement.
USE AdventureWorks;
DENY EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo
TO Recruiting11;
GO
...and your only reply is slàinte mhath
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply