Re: "act as part of OS" privilege necessary?
From: Bronek Kozicki (brok_at_rubikon.pl)
Date: 04/23/04
- Previous message: Yuan Shao: "RE: Copy SQL Users from a server to another"
- In reply to: Mike W.: ""act as part of OS" privilege necessary?"
- Next in thread: Kevin McDonnell [MSFT]: "RE: "act as part of OS" privilege necessary?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 23 Apr 2004 17:39:57 +0200
On Fri, 23 Apr 2004 07:38:56 -0700, Mike W. wrote:
> Is it really necessary for a custom SQL Server service
> account to have the "act as part of operating system" user
> privilege? My only guess is that it is required to perform
> Windows-based authentication. I'd like to know for sure.
this priviledge is not required for Windows-based auth. to work. In
fact, you may have pretty secure SQL Server without this priviledge
(running under regular user account) and configured for Windows-based
auth. only. However it's required if you want to use certain features
like allowing regular users access to xp_cmdshell or defining operating
system jobs in SQL Server Agent.
B.
- Previous message: Yuan Shao: "RE: Copy SQL Users from a server to another"
- In reply to: Mike W.: ""act as part of OS" privilege necessary?"
- Next in thread: Kevin McDonnell [MSFT]: "RE: "act as part of OS" privilege necessary?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
