Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jlrajan
Starting Member
6 Posts |
 Posted - 2004-12-01 : 17:34:48
|
| How to grant access to the master..xp_cmdshell? Currently, I am getting the EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'.Please adviseThanks |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-01 : 17:57:12
|
| You really don't want to do that do you? Are you the DBA? If you do, you would grant it like any other permission.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-01 : 22:52:09
|
| if you're the dba and you're trying to execute the command in an sproc, try calling the sproc via sql job. or, you could share a few information like, where are you going to use it, why do you need to use it and who are going to use it.otherwise, consult your dba--------------------keeping it simple... |
|
|
|
|
|
|
Execute permission on 'xp_cmdshell'