minimum OS user level to operate SQL Server

From: djc (noone_at_nowhere.com)
Date: 11/21/03

  • Next message: Julie: "Problem with code page 850 during 6.5 to 2000 conversion" 
    Date: Fri, 21 Nov 2003 11:57:01 -0500

    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: Julie: "Problem with code page 850 during 6.5 to 2000 conversion"

    Relevant Pages

    • Store program EXE in table?
      ... I have remote control software ... my application uses as its data storage system MSDE 2000 (with ... since I already have SQL Server running on the network I'd like ... Is there some way that I can either a) store my program files (one EXE ...
      (comp.databases.ms-sqlserver)
    • Re: SQL Server 2000 speed problems
      ... >> CREATE TABLE Control ... >> This is done by inserting a new row with the current time into the ... >> written to the database, and the writing needs to be fast, in the region ... >> similar that can be changed on SQL Server that could help solving this ...
      (microsoft.public.sqlserver.programming)
    • Re: DBA Access to SQL Server
      ... > look at the qualifications or trust of your sql dba ... > rather than his/her permissions. ... > 99.9% of the time i hear this question it's a control ... if your support model includes the DBA folks doing the SQL Server ...
      (microsoft.public.sqlserver.security)
    • Re: :: Control user access
      ... IMO it totally depends on the nature of the application. ... As you indicate SQL Server involvement, ... Microsoft MVP (Windows Security) ... > way to control user access in my application. ...
      (microsoft.public.security)
    • Re: using lookup and display only field as control field
      ... The control table would have only one row. ... assosciation between the two tables if the key field was null in both ... Of course, the syntax above is specific to SQL Server, but it's the ... Books Online for SQL Server 2005 at ...
      (comp.databases.ms-sqlserver)