Post reply

access to all SPs

  • May 16, 2007 at 3:57 am

    #178520

    HI,

    Is there a way to give exec rights to a user to all the stored procedures at one shot?

    sql 2005

     

    Thanks in advance

  • May 16, 2007 at 4:41 pm

    #706957

    I believe you need to grant 'exec any' to the users fixed server ID. I believe you need to enable some of those stored procedures, such as xp_cmdshell in the surface configuration tool, however, before they can be used.

  • June 15, 2007 at 12:34 pm

    #713370

    GRANT EXECUTE TO RoleOrUser

  • June 18, 2007 at 12:32 am

    #713494

    yes this works. think it is a new feature with 2005. thanks

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

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