Post reply

Grant permission to sproc

  • April 1, 2011 at 3:38 pm

    #235063

    In sql 2008, I would like to grant the execute rights of a stored procedure to a user. But why I cannot see the add button to add the user on the permission screen.

    In SQL 2005 I can see an add and a remove button there.

    Anything change?

    I do have rights though, for I can use grant sql statement and did it successfully

    Thanks

  • April 1, 2011 at 5:27 pm

    #1306731

    In 2008 you would use the "Search..." button to the right of "Users or roles:" to find an add a user, and then you can check the permissions in the lower "Explicit" tab.

    To remove a user you would clear all of their permissions from the "Explicit" tab and then click "OK".

  • April 1, 2011 at 5:36 pm

    #1306733

    Thank you, i got it.

  • April 1, 2011 at 5:53 pm

    #1306739

    I personally think that this change confuses a lot of people, and that they should name the button add. Also, it would be nice to have a remove button, rather than having to uncheck each of the permissions.

  • April 2, 2011 at 8:39 am

    #1306779

    I dont use the GUI much so I hadnt really noticed.

Viewing 5 posts - 1 through 4 (of 4 total)

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