On Wed, Jun 1, 2011 at 1:14 PM, Rafael Copquin <[email protected]> wrote: > Some time ago I asked how Word and Excel files could be saved into and > retrieved from a SQL Server table. With your help I successfully > developed a system in use by a cosmetics lab, that enables the users to > read and or save those documents. Because they are formulae for > proprietary makeups, powders, lipsticks, etc. they must be kept > absolutely confidential. > > All is well except that anybody with access to the database, with only > read rights to the documents can either copy, print or save the word > docs or excel sheets to their own private media (a pen drive) or even > email the documents. > > And this defeats the whole purpose of keeping the docs confidential. > > So my question is, what commands should go in the automation routine to > prevent copying, printing or saving the documents? > > For instance, what is the command in Word (or Excel), to prevent saving > a document? Ditto for printing or copying? ---------------------
How about security? Do they have an AD? Is there an existing group for them in the AD? If so just use that identity for read/write from your app against those tables. Then change the rights for the tables. use [YourDB] GO GRANT SELECT ON [dbo].[TableName] TO [SQLUser_WhoIsThatGroup ] GO Do they have a DBA there? If so ask them to set this up for you. This is only rights to read the data, none to write any. This how we keep prying eyes out of the HR db or employee tables in the mega DB. -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
