No, I am using "sa".

I have created two different instances and given
different password for each instance's "sa" login.

But i can attach a database from one instance to
another, Which should not happend.

Do u have any udea about using Encyption/Decryption. I
want to encrypt the data in VB before writing into SQL
Server.





--- John Thomas <[Email Address Removed] wrote:
> 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]


=====

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