List of Users

• Andrew Liles

  Mr or Mrs. 500

  Points: 520

  More actions

  August 2, 2006 at 5:19 pm

  #62096

  Hello All

  How can I select a list of users that have Execute Permission on a stored procedure? Or how can I list all stored procedures and also list what user have execute permission to each?

  Thanks

  Andrew

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 2, 2006 at 5:26 pm

  #652962

  Andrew,

  See this thread:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=296781&edit=1

  Greg

  Greg

• Andrew Liles

  Mr or Mrs. 500

  Points: 520

  More actions

  August 2, 2006 at 5:41 pm

  #652963

  Thank You Greg,

  That is perfect, I was looking thru the BOL, but had not come across this one. It worked perfect, gave me just the info that I need.

  Thanks again

  Andrew