Home Forums SQL Server 7,2000 Administration How to prevent our database to access any person RE: How to prevent our database to access any person

  • September 19, 2010 at 10:37 am

    #1223651

    kumar.sachu08 (9/19/2010)

    I hope microsoft will provide, any facility for the same in future.

    Sometime such cases come for DBA or developer. He don't want to share own database

    Sachin

    the technology already exists. you can load/unload an xml file to and from your datasets (dataset.ReadXML and dataset.WriteXml methods), and encrypt/decrypt the xml file so no one can look at it.

    Remember the objective of an agency having SQL Server is they have control over their own data. if you don't agree with that premise...that the clients data is theirs even though you built the framework the data will reside in, then you'll need to shift to less popular but more secure formats.

    you just cannot use SQL Server and hide everything from the administrator of that system.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!