Authentication and impersonation



I setup a intranet application based on windows integrated
authentication .


windows integrated authentication checked in IIS
and anonymous access unchecked.


i have used impersonation in my web config file
<identity impersonate="true" >
<authorization>
<allow roles="mydomain\group_a"/>
<deny users="*/>
</authorization>


a User A belongs to group_a but not to group_b


group_b is a group that i have added to SQL server in order to set
permissions on data.


i'm using a trusted connection to the SQL database throught a
webservice.


when i try to access the application in my browser with user A , as A
is member of the group_a , his access is granted to the page but he can
also access data in the database although he doesn't belong to group_b
configured in SQL server to access data.this user A doesn't belong to
any other group and has no login in SQL as well.


Why does this user have access to data although he has neither login
nor belongs to any groups that have access to sql server?


if we are using impersonation=true without any username and login
specified it's normally the authenticated user token that is used to
check the access to SQL server or did i missunderstood the mecanism?


if some could tell me what i did wrong , i would be very grateful.


Thank in advance for any help.


Eric

.



Relevant Pages

  • Re: Cant Connect
    ... Then it's likely the authentication settings on the IIS side ... Try adding the IUSR account as a login in SQL Server ... > Cn.open CnStr ...
    (microsoft.public.sqlserver.connect)
  • Re:changing sa password / login
    ... authentication and it worked. ... >I think you might have made changes to SQL Server ... >Authentication" can not recognize SA login which is SQL ... >configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... > If you use NT authentication, a user's permissions to a database are ... Your assertion that a user's permissions are independent of the application ... Even using Access and "exploring" will require an ODBC login to SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re:changing sa password / login
    ... I think you might have made changes to SQL Server ... to make was using Mixed Authentication which will ... Authentication" can not recognize SA login which is SQL ... configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos / Authentication to SQL2K
    ... use Windows integrated security for database access. ... That SQL Server be running on the same computer as IIS. ... > authentication until I switched on impersonation either. ... > When set up on my web server however, I get the "Login failed for user ...
    (microsoft.public.dotnet.framework.aspnet)