On Wed, Oct 14, 2015 at 11:31 AM, Kurt Wendt <[email protected]> wrote:
> We are making changes here at my job - they are switching over to 64-bit > SQL servers from the 32-bit servers. They've also been implementing > connections to Databases via the Trusted Connection. But, having to grant > permissions for various Databases on a per user basis is kinda nuts. So - > my manager had learned about the "Impersonating" term. So, supposedly you > have a general account/user - that could be used to access the proper > databases - and then each specific user Impersonates that general user. She > heard from others working in VB/.net - about doing the impersonation - but, > it sounds Code specific. So, that's why she was trying to figure out how to > do it via FoxPro. But, her searches on the Web was not really turning up > useful information. > > So - hopefully someone here can point us in the right direction. And, yes > - we are using VFP 9 SP2. > ---------------- Why not make AD Groups and put those groups into SQL Security instead of each user of that group? The only benefit I see of using impersonation is to run a process that is out of bounds and you can overcome it by stating to through code that jane is really superUser for this specific need. That may be for file access to write a file as one reason to do this. -- 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/cajidmykdlgexpo3nzt_8k5slckqvkgtj56swca_ttxetp96...@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.
