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-26 : 04:05:53
|
| Hi , I need to run batch file. It works using xp_cmdshell for sa(sysadmin) account.Is there any other way to execute batch file. If so give me idea.I was trying to give rights for developer account, but it was not success. Can you give me Syntax/procedure for giving exec rights to developer account.Thanks.Ravi |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-06-26 : 04:43:57
|
| Hi Ravi,I wrote a procedure to give rights to DB objects before couple of months. Please search in Pubs or project DB in 226 server.let me know if got it.Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled |
 |
|
|
ravis
Starting Member
7 Posts |
Posted - 2009-06-26 : 06:22:05
|
| Hi senthil, You wrote procedure named permission , it covered 'U','P','V','FN' objects only.Xp_cmdshell will not fall in those objects.I tried the following attempt , but it was fail. use masterGrant Exec on xp_cmdshell to developer |
|
|
|
|
|
|
acces to Xp_cmdshell