Database password

Hi,
I use SQL server 2000.
I would like to know if there is any way to lock my database (set my own
password) so that someone who don't know the password won't be able to steal
the data. For example copy mdf/ldf or create a export of the database and
attach it to another sql server, or even browse the database contents from
Enterprise Manager or any other utility.
Thanks in advance and happy new year!
hi,
Penny wrote:
> Hi,
> I use SQL server 2000.
> I would like to know if there is any way to lock my database (set my
> own password) so that someone who don't know the password won't be
> able to steal the data. For example copy mdf/ldf or create a export
> of the database and attach it to another sql server, or even browse
> the database contents from Enterprise Manager or any other utility.
it is not possible to password protect single databases..
as you already probably know, the security architecture of SQL Server is not
implemented that way... you have a 2 phases authentication mechanism of
logging to SQL Server, where it is evaluated wheter or not the specified
login (both WinNT and SQL Server) can access the server instance, and then
whether or not a valid database user is available in your db for the
corresponding login.. if the database user "Guest" is available and no other
db user is mapped to the corresponding login, that "Guest" db user will be
used and applied, while no db access is permitted otherway...
but the method is instance centric and not database centric...

> Thanks in advance and happy new year!
you too..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply