Your suggestion is good, provided that the authorized user is honest, or temptation free. But in a highly competitive market like the cosmetics ond, coupled to very lenient copyright laws in this country, temptation is always there. Especially if your competitor offers higher salaries or a big bribe.
So the guy authorized to have access could do anything with the document. Unless I am completely ignorant of SQL Server (which I am BTW) and there is a way to prevent users to do just that. If so, please lead me to where in SQL and how I set those restrictions. Rafael Copquin El 03/06/2011 10:05, Stephen Russell escribió: > 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. > _______________________________________________ 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.
