Post reply

create aUser that can create a stored procedure but cannot drop a stored procedure

  • August 2, 2005 at 9:12 pm

    #165108

    HI All,

    I am just wondering if it is possible to create a User that  can create(permission) a stored procedure but cannot drop a stored procedure?

    Thanks

    BabyJr

     

  • August 2, 2005 at 10:14 pm

    #579019

    Hi,

    I think so this is not possible, because of the user who created the procedure becomes the owner of the object. As SQL server says, by default the owner will have all the rights to do against the object. Hence he will have the previlage to drop the object.

    Unless otherwise the owner of object changed to somebody, he will be having the rights to drop the procedure which is created by him.

    If possible you try to change the owner of the object once the user created the object, then you award the permission of exec to that particular user.

  • August 3, 2005 at 3:36 am

    #579064

    Thanks a lot for the explanation

     

    BabyJR

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply