Thanks Stephen That does not answer my question though. But it is illustrative of how other companies want to hide sensitive data from snooping eyes (government, nosy employees, competitors, etc) In my client's case, it is about not sharing confidential sales data, building plans and management salaries with the local staff Some of their employees can steal this information and sell it to outsiders
And yes, the databases are on a desk PC My problem is to determine why the data persists in memory and how to prevent it Rafael <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> 2017-11-10 16:33 GMT-03:00 Rafael Copquin <[email protected]>: > One of my clients uses a VFP9 app with MSSQL SERVER databases > > Two databases > > database A stored in the hard disk (C:) > > databaseB (with confidential data) stored in an external hard disk > (E:) > > The Sql Server Management Studio correctly shows, in each database > properties windows, in the files option, that the A database resides in > disk C and the B database resides in disk E > > However, if I physically remove the hard disk (E:), the management studio > still shows all tables of database B and select statements show data from > the applicable tables. > > I thought that the data resides in memory in the cache. So I disconnected > the SSMS from the engine, even turned off the SSMS. Then, when the SSMS was > up again, it would still show the database B (even if its lodging HD was > disconnected and put away in a drawer) and queries would still show data > from any of the tables. > > What is going on? > > How can I prevent this "ghost" behaviour? > > It is very important that, when the external hard disk is removed, no > confidential data can be read at all. > > Rafael Copquin > > > > > --- > Este correo electrónico ha sido comprobado en busca de virus por AVG. > http://www.avg.com > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAHM-jJ3y9ubiqo0JtKCWUi4yFO_DwsbSxjXpP4Pxnai=r9g...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
