On 10/14/2015 12:31 PM, Kurt Wendt 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.
I've never heard of 'Impersonating,' but it sounds like all she needs is
simply Server authentication.
1) Create a SQL Server Login, under the Security tab, give it a PW, and
make it owner of the database in question.
2) Have users login with NT Login, instead of Windows authentication.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
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/[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.
