Minimum permission to run exec sp_helpsrvrolemember

  • What is the minimum permission for a user to run exec sp_helpsrvrolemember 'sysadmin' ?

    Thanks in Advance !

    Sanz
  • it's detailed in Books online and requires membership of the Public role

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Yes. I have seen that from BOL. But in my case giving public privilege returns only user 'sa'.

    Sanz
  • yes i see what you mean, the following shows correctly the server role members but probably shouldnt be granted to ordinary users

    grant VIEW ANY DEFINITION TO [youruser]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • That helps. Thanks a lot 🙂

    Sanz

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

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