Re: XP_CMDSHELL
From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 04/29/04
- Next message: Daniel: "Re: Database Design Problem"
- Previous message: Chris Barber: "Re: Error 3197: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time."
- In reply to: Pluto: "XP_CMDSHELL"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 22:03:36 +0530
Pluto,
When master..xp_cmdshell is called by a user who is a member of the sysadmin
fixedserver role, master..xp_cmdshell will be executed under the account's
security context in which the SQL Server service is running.
If the user who calls master..xp_cmdshell is not a member of the sysadmin
role, master..xp_cmdshell will impersonate the SQL Server Agent proxy
account, which is specified using xp_sqlagent_proxy_account.This is for
SQL2000 (in Enterprise manager, right click sql agent | properties and check
in 'Job system' tab). For SQL7 it will be run under a local account named
SQLAgentCmdExec.
-- Dinesh SQL Server MVP -- -- SQL Server FAQ at http://www.tkdinesh.com "Pluto" <anonymous@discussions.microsoft.com> wrote in message news:60b301c42e04$76507df0$a501280a@phx.gbl... > Hello people > I'm I right in thinking the xp_cmdshell is executed with > the same user as starts the MSSQLServer ? > >
- Next message: Daniel: "Re: Database Design Problem"
- Previous message: Chris Barber: "Re: Error 3197: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time."
- In reply to: Pluto: "XP_CMDSHELL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
