Documentation of Execute Permissions on Stored Procedures - 2000

• crzystevielvr

  SSC Enthusiast

  Points: 156

  More actions

  September 1, 2011 at 9:00 am

  #247230

  Hello All,

  I am working in SQL 2000 and am trying to find a table or view that documents who has execute permissions on stored procedures, OR what stored procedures a user is able to execute. Any help with this would be greatly appreciated. Thank you so much!!! 🙂

• crzystevielvr

  SSC Enthusiast

  Points: 156

  More actions

  September 2, 2011 at 8:07 am

  #1376452

  Nevermind; I found sp_helpprotect, which was perfect for this! 😀