Was hoping for an easier way out of the box... On Oct 21, 10:59 pm, Eddie Pequeno <[EMAIL PROTECTED]> wrote: > Hey Mike, > > I haven't used Active Directory in quite some time but I created an > intranet webapp once that used Active Directory for universal login > credentials so that the users can use their same windows login as the login > for the webap. I was able to query the Active directory to get the users > login but did not store it in the database although it could have easily been > done. > > I guess there are really 2 main operations here. 1. Get the users AD info. > 2.Sync up AD with the datbase after you store their info. > > For the first party you can just query aginst the Active Directory to get > what you need. Just use the canonical name to search for the correct data. > The second part of this could be handled by stored procedures. If you use > stored procedures to CreateUser, UpdateUser, DeleteUser. Then you can call > those stored procedures when you are updaing the user in the Active directory > that way you'll be able to sync up the info in the db and ad. > > -Eddie > > Shane Heasley <[EMAIL PROTECTED]> wrote: > > Mike: > > Did you get an answer to this question? I was out of town for a > week. It is possible to pull the logged in user's AD info (in a > Windows environtment) using cgi.Auth_User (or something very similar - > I'm doing this from memory). However, that is only if you have > authentication set in IIS so this approach will not work for a public > site. > > What exactly are you trying to accomplish? There might be a different > route to the same results. > > Cheers, > > Shane > > On Oct 12, 11:36 am, Mike Gillespie wrote: > > > Is there a way to get user account data/attributes from active > > directory into a table in a SQL server and while keeping AD as the > > authoritative source keep the data synchronized in the SQL server > > table? Is there some kind of data transformation utility that can be > > used? > > > Would need new users added to AD to be inserted into the table and any > > attributes that are changed to be updated in the table. This can be a > > scheduled task or preferrably a rea-time synchronization. > > > If this is possible, can someone point me to some documentation? I'm > > an Oracle and mySql guy not a SQL server one.. > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection > aroundhttp://mail.yahoo.com
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [EMAIL PROTECTED] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
