list all store proc without exec permission

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  February 17, 2010 at 8:06 am

  #138280

  I have a user that would like to see what store procs are available in the database. But he will not have any execute rights on the store procs. is there anyway I can accomplish this.

  Thanks

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  February 17, 2010 at 10:09 am

  #1120229

  you could grant access to the sys.objects view or you could create your own view and give them access to that

  something like this would do it.

  select name

  from sys.objects

  where type = 'P' and is_ms_shipped = 0

  order by Name

  Out of curiosity, why would you do this??