Stephen, Thanks for the reply. In regards to "AD" - that refers to Domain??
And, to answer your other comment - yes, there may be at times when a Stored Procedure has to write a file. I'm going to pass your comments on to my manager - and will follow-up again here if she has further questions. Regards, Kurt -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Wednesday, October 14, 2015 12:49 PM To: [email protected] Subject: Re: To Impersonate on MS SQL 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 --- [excessive quoting removed by server] _______________________________________________ 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/80838f1ca795b14ea1af48659f35166f24b...@drexch02.corp.globetax.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.
