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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2007-01-10 : 18:23:55
|
| I was getting an error.. when I try to run xp_cmdshell as a user who dosn;t have a sysadmin acount.. xp_cmdshell failed to execute because current security context is not sysadmin and proxy acount is not setup correctly. For more information, refer to Book Online, search for topic related to xp_sqlagent_proxy_account."So I've created a porxy account and create a login and give an execute permmion on XP_cmdshell SP... I would like to know whether they will be any harm on DB by creating a proxy account? |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-11 : 12:04:04
|
| The proxy account is used for xp_cmdshell and SQL Server Agent jobs to access OS and network resources, it is not used for database access at all, so it will not have any affect on database security. All database access will be performed using the user's regular account. |
 |
|
|
|
|
|
Proxy account to run xp_cmdshell