Re: Hierarchy in user management

From: Bob Gregory (bobgregory_at_ppsltd.net)
Date: 09/22/04


Date: 22 Sep 2004 04:29:16 -0700

Hey Rich thanks for the reply,

"richlm" <rich_lm@h0tmai1.com> wrote in message news:<#5tbB1BoEHA.2684@TK2MSFTNGP11.phx.gbl>...
> Not much specifically in .NET that can help to solve the
> architectural/scaleability issues here.

No, I'm more looking for architecture tips, but there isn't a .Net
architecture group that I'm aware of.

>
> Using AD to store your organizational heirarchy + users sounds like a good
> choice, and I don't think you can avoid having to store your widgets etc. in
> SQL server.
>

I'm fine with storing my widgets in SQL, that's what it's for. My
question more specifically, is how can I integrate my user directory
with SQL, or do I need to handle that myself?

IOW, is there a native way to use the results of a search on an active
directory against SQL or do I need to write a wrapper to do all that
for me?

If not then you end up posting delimited strings or XML to SQL to
represent a list of users and that's something I want to avoid if
possible. I suppose I could use a template query and include the
results of my ad search in the template, but I detect the first whiffs
of CodeSmell.

Anyone know anything about returning XML from an active directory?

> You might want to look at Microsoft "Authorization Manager" (AzMan) - a new
> feature in Windows Server 2003.
> I'm not sure it can address all of your requirements but it might help.

I've heard vague rumblings about AzMan. I'll have another look at that
and see what occurs to me.

Cheers

-- Bob



Relevant Pages

  • Re: Performance problem...
    ... else review the architecture. ... If you determine it's a database problem, ... SQL Server MVP ... > performance problems with a VB6 application running over a SQL Server 2000 ...
    (microsoft.public.sqlserver.tools)
  • [Full-Disclosure] [SECURITY] [DSA-347-1] New teapop packages fix SQL injection
    ... escape user-supplied strings before using them in SQL queries. ... privileges of the database user as which teapop has authenticated. ... If you are using the apt-get package manager, ... Alpha architecture: ...
    (Full-Disclosure)
  • [SECURITY] [DSA-347-1] New teapop packages fix SQL injection
    ... escape user-supplied strings before using them in SQL queries. ... privileges of the database user as which teapop has authenticated. ... If you are using the apt-get package manager, ... Alpha architecture: ...
    (Bugtraq)
  • Re: MCSD Solution Architecture exam
    ... I thought the architecture one was one of the easier ones. ... Save for the SQL one, I was a little disappointed with the difficulty of the ... My last exam is the Solution ... > does the Solution Architecture exam compare? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Is there a way to convert ms sql 2008 tables to XML files?
    ... After looking at the code I made it work, since I removed 2 nVARCHARcolumns from the SQL statement where it is used as an RTF. ... I have the 2 XML files the bad and the good which are below: ... Verdana;}{\f1\fnil\fcharset0 Microsoft Sans ... Here is the actual string copied from the ms sql 2008 which works fine; ...
    (microsoft.public.dotnet.framework.aspnet)