Jim Lawrence (AccessD)
accessd at shaw.ca
Thu May 1 19:32:48 CDT 2003
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