Mehyar Posted February 27, 2004 Posted February 27, 2004 Well guys, it has been ages since I have been last here... But its good to be back.. I have a question, If my client has an SQL Server (he is using it using enterprise manager), and I gave him the MDF and LDF fiel of a certain database. Can I in some way prevent him from having access to that database (since I am delpoying my project on SQL Server) Note that he my client is an administrator on the SQL Server..... Thx in Advance... Quote Dream as if you'll live forever, live as if you'll die today
samsmithnz Posted February 27, 2004 Posted February 27, 2004 ONly by changing his log on permissions. You can specify the rights to each database though, so even though he's an 'admin' at the moment, as long as he's not using the sa account you can give him only 'select' permissions on your database... Quote Thanks Sam http://www.samsmith.co.nz
Mehyar Posted February 27, 2004 Author Posted February 27, 2004 But its his computer, I cannot deny him accessing the Enterprise manager with sa account. I want to deny him access to the database of my program only. And I cant just tell him dont use the sa account on my database, I need to find a way to prevent even the sa account from accessing it.... Quote Dream as if you'll live forever, live as if you'll die today
samsmithnz Posted February 27, 2004 Posted February 27, 2004 You can't so that... sa is a system account and can by its very nature access everything, if you're not willing to change the permissions to this account, and the client is unwilling to use a different account there is nothing you can do to prevent the client from accessing your database. Quote Thanks Sam http://www.samsmith.co.nz
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.