On Wed, Jun 1, 2011 at 5:09 PM, Rafael Copquin <[email protected]> wrote: > You're not being naïve at all. Maybe I did not express myself correctly. > > The way my system works is this: > > Whenever a user, previously authorized by his/her password to examine > the documents, wants to read a doc, xls, pdf file, it is the program > that pulls the requested file and shows it in the screen for the user to > read. > > I then use the _environment.vcx that ships with VFP to shell execute the > document. It can be read, modified, saved, printed, emailed, etc. This > are precisely the possibilities I want to prevent the users to have. > > I just want them to read, and only read the Word, Excel or PDF document. > No modifying, printing, saving, emailing...... Of course if they use > their cell phone to take a picture of the screen, well, then I'm > screwed, but other than that..... > > Am I clear now? -------------
It becomes a RIGHTS issue correct? Either you can view / edit those secret documents or you cannot. That being said SQL Server is great at thwarting users because of insufficient rights. Why not set up two users for the database one with rights to those tables and the other user without the rights. Just as a guess your connection to the db for all of our VFP work is with a user that has sysadmin rights. Something that scares the crap out of dba. -- 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.
