Re: Split roles

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/28/05


Date: Tue, 27 Sep 2005 20:49:11 -0500

The rights needed for the service accounts are outlined in
the following:
 HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811

If the dba just runs Enterprise Manager...that's not a good
thing. But in that case, the dba could just be a member of
the sysadmins group in SQL Server.

-Sue

On Tue, 27 Sep 2005 10:28:58 -0600, "Bad Beagle"
<maxwelli@nospam.postalias> wrote:

>Can someone please let me know what are the best practices for securing a
>sql server? The department is split - I have dba's and network analysts.
>The dba's are responsible for sql and the network analysts are responsible
>for the os.
>
>What rights are required for the service accounts?
>What rights does the dba need on the server to run Enterprise Manager?
>



Relevant Pages

  • Re: xcopy deployment to sql server DTS package in restricted envir
    ... Try using Run As with the DTS package. ... William Vaughn ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: xcopy deployment to sql server DTS package in restricted envir
    ... you either need to have the DBA create a SQL login for the application or for the class of users that will use the application and grant rights to that login for the specific resources the application uses--and no more. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... when I was working on the team) to get rights management tools integrated ... Hitchhiker's Guide to Visual Studio and SQL Server ... actually be able to connect to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: xcopy deployment to sql server DTS package in restricted envir
    ... We created an account specific for this application with full rights (as far ... also wondering if I have to digitally sign the .exe or something. ... Hitchhiker's Guide to Visual Studio and SQL Server ... When you say I need to grant rights to the group to which I belong, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... To be fair, VS is a "generic" tool designed to front a variety of backend databases, but each of the serious engines have rights management needs as well. ... But the more I think about how connecting to a database is setup and the trouble it's been, the more it just pisses me off. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)