Split roles

From: Bad Beagle (maxwelli_at_nospam.postalias)
Date: 09/27/05 

Date: Tue, 27 Sep 2005 10:28:58 -0600

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: Split roles
    ... > Can someone please let me know what are the best practices for securing a ... The department is split - I have dba's and network analysts. ... > What rights does the dba need on the server to run Enterprise Manager? ...
    (microsoft.public.sqlserver.security)
  • 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: 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)