[dba-SQLServer]Security

You can install a named instance and transfer those databases to it.  In
the new instance remove Buitin Administrators from System Administrators
server role and set SA password to something other than what it is on
your default instance.

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk] 
Sent: Tuesday, August 19, 2003 10:18 AM
To: dba-sqlserver
Subject: Re: [dba-SQLServer]Security


Robert

Is there no way to do this on the same server?

Martin


----- Original Message ----- 
From: "Djabarov, Robert" <Robert.Djabarov at usaa.com>
To: "dba-sqlserver" <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, August 19, 2003 4:01 PM
Subject: RE: [dba-SQLServer]Security


> Move those DBs to a dedicated server and lock them from the DBAs
> 
> -----Original Message-----
> From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
> Sent: Tuesday, August 19, 2003 8:56 AM
> To: dba-sqlserver
> Subject: [dba-SQLServer]Security
> 
> 
> We have a two DBs whcih contain very sensitive information. We have 
> several SQL Server Admins.
> 
> Is it possible to have the two DBs locked out to all but specific 
> DBAs?
> 
> Martin
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com