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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2003-12-19 : 14:43:30
|
| Hi,We have a user User1 in database db1 to which we want to give execute permission on procedure xp_cmdshellWhen I am running statement like : grant execute on dbo.xp_cmdshell to user1….getting error : Server: Msg 4604, Level 16, State 1, Line 1There is no such user or group 'user1’Do we need to add user1 as a user in database master or what is the correct procedure to give permission?Thanks--rubs |
|
|
|
|
|
xp_cmdshell permission