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! L8r, -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Thursday, October 15, 2015 9:35 AM To: [email protected] Subject: Re: To Impersonate on MS SQL On Thu, Oct 15, 2015 at 3:33 AM, Alan Bourke <[email protected]> wrote: > By impersonation she potentially means issuing a T-SQL 'EXECUTE AS > <login>' instruction, specifying that all subsequent commands issued > during that connection/session are executed with the privileges of the > login specified. > > So presumably from VFP, it would be sending in queries like: > > 'EXECUTE AS xyz;select * from mytable where account=?' > ------------ Still think they are grasping at straws for correct security setup of the server to begin with and stumbled across this clause as the fix, instead of generating AD Groups with correct rights. -- 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.
