Post reply

Deleting of object will effect permissions

  • April 23, 2010 at 4:04 am

    #144250

    hi ,

    I have one SP. Some users only have executable permissions.

    Now i am dropping it & recreating with the same name..

    My Question is that the User who have exec permissions can have same rights

    or i have to give the permissions again....

    Thnaks!

    Sasidhar Chowdary

  • April 23, 2010 at 4:21 am

    #1156690

    If you drop and recreate the stored procedure, you will need to add the permissions in again. However if you used ALTER the permissions would be kept and you would not need to add them in again.

  • April 23, 2010 at 5:36 am

    #1156728

    Whenever you drop any object , sql will remove everything related with it.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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