Re: minimum OS user level to operate SQL Server
From: Ray Higdon (rayhigdon_at_higdonconsulting.com)
Date: 11/21/03
- Next message: Carlos Eduardo: "Who installed"
- Previous message: Steve Thompson: "Re: SQL Server Password - error 1069"
- In reply to: djc: "minimum OS user level to operate SQL Server"
- Next in thread: djc: "Re: minimum OS user level to operate SQL Server"
- Reply: djc: "Re: minimum OS user level to operate SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 21 Nov 2003 13:49:12 -0500
They don't need to have any windows security, you can assign this all
through SQL. Just the service that runs SQL will need windows security.
Making them a system administrator would give them full control over SQL.
HTH
-- Ray Higdon MCSE, MCDBA, CCNA -- "djc" <noone@nowhere.com> wrote in message news:u9rrYCFsDHA.2508@TK2MSFTNGP10.phx.gbl... > I need to know what the minimum is for a user to have full control over > SQLServer2000 but nothing else in the OS. > > A while back I was in a rush to get someone access and had problems. I wound > up making the user account a member of the 'server operators' windows > built-in security group. I really don't want to keep it that way. > > 1) What windows permissions/privelages are needed at a minimum to have full > control of SQL Server. > 2) What SQLServer permissions/privelages are needed at a minimum to have > full control of SQL Server. > > Thanks! > >
- Next message: Carlos Eduardo: "Who installed"
- Previous message: Steve Thompson: "Re: SQL Server Password - error 1069"
- In reply to: djc: "minimum OS user level to operate SQL Server"
- Next in thread: djc: "Re: minimum OS user level to operate SQL Server"
- Reply: djc: "Re: minimum OS user level to operate SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
