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 |
|
ravis
Starting Member
7 Posts |
 Posted - 2009-06-05 : 05:49:43
|
| Hi all,I created developer login and given all rights to developer, but i can't able to exec Xp_cmdshell under developer login. How I should give permission for this.Thanks.Ravi |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-05 : 06:16:56
|
refer to the BOL http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx on the Permissions sectionquote:
PermissionsExecute 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.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-06-05 : 07:13:30
|
quote:
Originally posted by ravis
Hi all,I created developer login and given all rights to developer, but i can't able to exec Xp_cmdshell under developer login. How I should give permission for this.Thanks.Ravi
Hi ravi,Will u able to provide permission for developer user?once u get it inform to me.i'm curious to know how it will be!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled |
|
|
|
|
|
|
permission to developer login for Xp_cmdshell