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 |
|
CanadaDBA
583 Posts |
 Posted - 2004-10-26 : 13:35:30
|
I have a user id witch is a member of public, db_datareader and db_datawriter. I want to run the following comand in QA. exec @I=master.dbo.xp_cmdshell 'dtsrun /S 1.2.3.4\Test /E /N Import_DTS' And I get the following error:Server: Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 12EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'.I remember it was working with this user id but now it is not. It works when I use a user id with DBO membership. What's the problem?Canada DBA |
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-26 : 13:48:36
|
| I found this in BOL:Execute permissions for xp_cmdshell default to members of the sysadmin fixed server role, but can be granted to other users. Important If you choose to use a Windows NT account that is not a member of the local administrator's group for the MSSQLServer service, users who are not members of the sysadmin fixed server role cannot execute xp_cmdshell.Canada DBA |
 |
|
|
|
|
|
EXECUTE permission denied on object 'xp_cmdshell'