[dba-SQLServer]SQL2000 Security - Preventing access

Thanks Jim and Billy,

At 1/05/2003, you wrote:
>Hi David:
>
>If anyone gets access to your server room and the tapes stored there; there
>is nothing they can not take. That is why Server rooms are usually securely
>locked.
>
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of David
>Emerson
>Sent: Thursday, May 01, 2003 3:39 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer]SQL2000 Security - Preventing access
>
>
>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
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com