July 15, 2004 at 7:26 pm
Hi all,
I am going to deploy an application that uses SQL Server 2000 as a backend. I have issues on how to set a password or prevent access to the SQL Server 2k database for my application specifically. So let me be clear by giving an analogy. Let's say I created a software called Address Book. The address book uses the database called dbAddress. I am going to deploy this software on a site that has SQL Server 2k database already, that is administered by a dba. The issue at hand is that dbo (system administrator account) has full priviledges to everything. How do I prevent even the dba to have access to dbAddress. Is there someway to password protect the database file I am going to send like I can with an mdb file (Access database file) ? Any help will be appreciated
Thanks
David
July 19, 2004 at 1:57 pm
About the only thing you can do is encrypt the data. The system administrator (sa) requires full access to all objects within SQL server to be able to do his/her job. Any dba who is worth his salt would not take personal advantage of having access to data or schema, and sometimes it is advantageous for the dba to have access to the data, in order to troubleshoot issues that you may be having.
Steve
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply