Does the Server allow NT Authentication ?

You are probably getting your access thru your NT Login.
If you are an admin for that machine, SQL Server is going
to give you SQL admin privilege thru builtin/administrators login.

John
www.ideo.com

-----Original Message-----
From: Bajal Mohamed [mailto:[Email Address Removed]
Sent: February 26, 2003 12:09 AM
To: LazyDBA.com Discussion
Subject: How to protect a database from DBA's invasion ????????


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/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page