On Thu, Oct 15, 2015 at 8:48 AM, Kurt Wendt <[email protected]> wrote:
> Stephen - I agree with you. And, it's the reason why we started using the > " Trusted_Connection=True; " option in the connection string. Since, if > connections for a user is based upon Groups - and those belonging to a > particular Group would then have the proper access. > > Thanks again for your input. And, should you ever get out to Long Island > again - it would be great to get together over some Beers! > --------------- Let Go Mets! What you are suggesting to alter your code in VFP is kind of nuts, unless you pass your string to a prefix it with the execute as statement all the time. In reality you have 3 users to your db. Read Only for reporting applications outside of your app. Read Write for CRUD work that all users have to do. DBO for super users that need to create table on the fly for maintenance operations as one type of special need. Within your CRUD you can have a lot of sub rules like nobody outside of HR can see anything about the employees outside of a vew that pulls salesman names for use all over the place. As the company gets bigger the rules follow. :) Thus having the Groups in AD set up I only have to set the profile once and tweak all over as new rules are presented. In my db different tables are used to separate the business of our Canadian or UK units from USA ones. Same schema just a different table is called as needed in the session, business experience. I didn't think this up I just have to live with it. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/CAJidMY+tLDF_ARS9-HUR3-05+fHat=dkdin9snuthtrxaec...@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.
