Security issue in sql server

[JawwadLone]

I want to deploy my database in sqlserver 2000 to my client. My client is already using sql server for other databases and he has the password of sa. Now i want to restrict all the users not to access its structure, except my own created user.
Is it possible for me to restrict sa also from viewing my database without changing his password? Can any one help me in resolving this problem.

Regards,
Jawwad Lone.

 

[SQLBill]

SA is the 'ultimate' account. It accesses everything.

I don't even think that installing a new INSTANCE of SQL Server will allow a second SA account. I believe the SA account is for the total SQL Server installation. But you could try to install a second instance and see if it allows you to give the new instance a separate SA account.

-SQLBill

 

[SQLSister]

If you install SQL Server on a different server, you can assign a new sa password, but personally I would not want any database at my office that I did not have full admin rights to. Why would I buy a product I couldn't do the maintenance on myself? I'm not going to pay a consultant every time I want to change the backup schedule or add a new user. Every commercial product I've ever used has given the company admin rights to their own database. They just void the warranty and charge you really big bucks to fix it if you muck up their database structure.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief