September 02, 2010     |
Network Toaster
SQL Security Forums
Note: SQLSecurity.com does not allow nor require registration due to privacy concerns for users. SQLSecurity.com is open and anonymous for all. Please report any abuse or profanity.
Reply To Message:
Posted By n/a on 1/1/2001
Subject: Who is granted EXECUTED on xp_cmdShell
Message: Yes - and if you DO grant someone access to execute xp_cmdshell then you should see them when you execute sp_helprotect xp_cmdShell

As an example I just granted the public role access to the procedure and now my output from the above is:

Owner Object Grantee Grantor ProtectType Action Column
------ ---------------------- ------------ ------- ----------- ------- ------
dbo xp_cmdshell public dbo Grant Execute .
UserName: 
Subject:  Who is granted EXECUTED on xp_cmdShell
Body:
  
Show Replies:


ActiveForums 3.6
Copyright 1999 by Chip Andrews   |  Privacy Statement  |  Terms Of Use