Re: Sql To Active Directory Challenge

From: Nikolay Petrov (johntup2_nospam__at_mail.bg)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 14:12:18 +0200

My opinion is that (if possible, I don't know, but 9/10 it has this
capability) it is much easier for SQL server to check if a user is a member
of Active Directory or Local Windows groups.
This way you can check the group membership in SQL and only return the
allowed apps list, you'll not need to check the membership in your app.
You should look at SQL Documentation on MSDN about how to check the
membership.
If not possible, you can get the group membership from your app, send it to
SQL stored procedures and get the apps for this group. But you should store
group names instead of usernames in SQL.

Relevant Pages

  • Re: Replacing VS .NETs SQL Server Express Edition Integration
    ... As you said you already have an existing database that contains the ... membership structure, ... Replacing VS .NET's SQL Server Express Edition Integration ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DataAdapters and Parameters
    ... server goes down and we need to check a customer's membership. ... using SQL Server and ASP.NET via our intranet. ... I guess I could go with a synchronized SQL database?... ... >> downtime backup, that is why I am currently working with Access. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: loop and recordset
    ... those members whose membership lapsed. ... Use the SQL language to return only the set of required ... This table obviously needs some constraints. ... ALTER TABLE enrollment_2 ADD ...
    (microsoft.public.access.modulesdaovba)
  • Re: Membership functions connect to Sql Server as Process Identity, not user identity??
    ... as i said - you could just use the source of the sql provider released by MS last week and remove the impersonation/revert to self code - look out for calls to "SqlConnectionHelper.GetConnection" ... forms authentication and the membership class for everything. ... to sql server, including connection pool issues, but that's the way it ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Sql To Active Directory Challenge
    ... Do you know if sql has the ability to see which groups a user is a member of ... So i could basically supply a username, it checks what groups a user is a ... > allowed apps list, you'll not need to check the membership in your app. ...
    (microsoft.public.dotnet.languages.vb)