Script logins of stored proc

• Imke Cronje

  SSCarpal Tunnel

  Points: 4826

  More actions

  January 25, 2008 at 2:26 am

  #121906

  Hi there,

  Is there perhaps a way in SQL where you can display a list of stored procs on a database with the logins associated to that stored proc. eg. a list of user logins may have execute permissions on a stored proc.

  Please Help

  IC

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 25, 2008 at 2:36 am

  #771626

  Yes, there is. Look up the sys.database_permissions metadata view.

  John

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 25, 2008 at 3:44 am

  #771637

  will it show a list of stored procs ?

  "Keep Trying"