----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VinodK [TLabs, SCT] Message 2 in Discussion Hi Saxena, Well no takers for a genuine SQL Server question ... :) ... Well, let me try it ... >> Could it be possible to let only desired user to see my SQL Server DataBase? Yes, it is quite possible to do this. You can assign particular users alone to view the database. But keep in mind that the System Administrators can have all the control on any database as they are the systems admin ... And the user "sa" is no exception ... Having said that I DONOT recommend you to remove the sa previledges also because it is the user account for "dbo" role ie even if sa does something on the database like creating objects it goes under the database owner account. What I strongly recommend is to secure your sa password. Or on the contrary can allow only integrated authentication. Doing so no other user can infiltrate into the system. Once you make the user as the db_owner role then he has all the rights on the system. Donot give him any other extra previledges. Then you are all done in the configuration. >> Is there Any Free Encription / Decription Control Available on Net that i can use in my Home Project? Now if your question is how to secure it on SQL Server .. Then here is an article that tells you how to enable encryption after intalling SQL Server ... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_servp_36es.asp?frame=true HTH, Vinod Kumar SCT Software Solutions ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
