Post reply

to lock the particular stored procedure

  • January 24, 2008 at 5:07 am

    #186054

    Hi All,

    Is it possible to lock the particular stored procedure/Function in sql server?

  • 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