Hi Pals,

I have designed database for “Personnel System” and it
is ready for use. Now my boss says that only one
person should have full rights on this database. He
don’t want even myself (as I am a DBA here) to have
access on this Database.

Here we have only one server (Win 2k with SQL 2k).

For this purpose, I have installed new instance and
named it as “Personnel System”, this instance’s “sa”
password is given to my boss. I mean he is the only
one person can access this database now.

But I found that, I can still attach this “Personnel
System” database to another instance of sql server and
open the database fully & modify. By doing this I
realize that our “Personnel System” database is not
protected well from intruders.

Is there is any way to secure a database (from the DBA
though it was designed by him)?.

The main purpose is “my boss don’t want to give me an
access to this database (I am the one SQL Server DBA
here).

Advanced thanks for ur ideas & suggestions


=====

Best Regards,
Bajal Mohamed.

YOUR ATTITUDE IS YOUR ALTITUDE




__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
MS Sql Server LazyDBA home page