How to determine users with right to System Stored Procedure

• boyeneye

  Valued Member

  Points: 68

  More actions

  February 1, 2011 at 5:36 am

  #234372

  Is there any sql command that i can run to determine users that have execute right on the listed Stored Procedure?

  xp_available media

  xp_dirtree

  xp_dsninfo

  xp_enumdsn

  xp_enumerrorlogs

  xp_enumgroups

  xp_eventlog

  xp_fixeddrives

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  February 1, 2011 at 7:14 am

  #1280913

  Check if sp_helprotect meets the requirement. Here is an example.

  sp_helprotect 'xp_fixeddrives'

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• boyeneye

  Valued Member

  Points: 68

  More actions

  February 7, 2011 at 3:50 am

  #1283017

  Thanks Adiga... I guess your post will help.

  regards.