Windows Authentication

From: Eran Librach (eran.librach@verizon.net)
Date: 01/02/03 

From: "Eran Librach" <eran.librach@verizon.net>
Date: Thu, 2 Jan 2003 07:23:33 -0800

I'm not sure about VB6, but there is a mechanism in Win32
to impersonate another login, called
ImpersonateLoggedOnUser, used alongside LogonUser.

If done correctly, you can have your application ask the
user for a username/password and use these to impersonate
that user. While impersonating, any new SQL sessions
should see the impersonated user.

Hope that helps.

-Eran

>-----Original Message-----
>Can anyone tell me if this is possible using VB6 and SQL
>2000?
>
>I am using Windows Authentication in SQL so that I don't
>have to create logins. All the domain users in my domain
>are created as a single login. The Public group has no
>permissions. Individual users from the domain are
created
>and placed in a user group that has permissions to the
>database.
>
>My dilemma is this. I want a user to be able to login to
>my application from a workstation that they are not
>currently logged into. I already know how to validate
the
>user's Windows login and password. But I believe SQL's
>Windows Authentication doesn't care about my VB user, it
>cares about the user that is logged onto that
workstation.
>Is it possible for me to connect the user to the
database
>using Windows Authentication and the user id of the user
>logging into my app?

Relevant Pages

  • Re: client impersonation
    ... While you are able to retrieve the login names of all current ... Why not create a simple client autostart ... tool that makes a request to the webservice with the user's login ... impersonate the client user to have the appropriate rights on the ...
    (microsoft.public.win32.programmer.tapi)
  • Going from anonymous security to Windows Security in an ASP.NET application
    ... We have to validate users on an anonymous/public-website using a custom ... From this login page we redirect them to an extranet site, ... them sharepoint information, etc. e.g. from this point on their web requests ... For them to use the sharepoint functionality we need to impersonate a ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • FileStream Encrypted Impersonation Problem
    ... I need to be able to store the login information for the remote services in ... To do this I was going to create an encrypted file containing the login ... Encrypted under the service's login account. ... If I impersonate the current windows logon (using LogonUser to get the ...
    (microsoft.public.dotnet.framework)
  • Re: Impersonating user
    ... You mean you want it to impersonate whoever logs in, but never give a login? ... use windows authentication and you are fine. ... The windows auth dialog only pops up when the user cannot be determined. ... you can impersonate a single user rather easily. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Impersonating, User profiles and Printers
    ... I know by know that I cant access the printers with the ASPNET (or ... Is there a way, to Login, impersonate and then load the ...
    (microsoft.public.dotnet.framework.aspnet.security)