[dba-SQLServer]SQL2000 Security - Preventing access

AFAIK the answer is no,  there nothing you can do to prevent them from being 
able to access the data if they bring home the db file.

Billy



>From: David Emerson <davide at dalyn.co.nz>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]SQL2000 Security - Preventing access
>Date: Fri, 02 May 2003 10:39:28 +1200
>
>We are in the process of completing a new installation.  We have created a 
>runtime WXP ADP with a SQL2000 BE.  We have set security so that users that 
>log onto the program can only access the parts that are relevant to them.  
>Fine so far.
>
>What I haven't worked out yet is - What happens if someone gets hold of  
>the SQL database file (say for example from a backup tape), takes it home 
>and attaches it to their own copy of SQL.  Is there any way to prevent them 
>from being able to access the data or objects?
>
>
>Regards
>
>David Emerson
>DALYN Software Ltd
>25b Cunliffe St, Johnsonville
>Wellington, New Zealand
>Ph/Fax (877) 456-1205
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus