Thread: Active Directory
Is anyone familiar with any Windows Active Directory integration for user information. I have a customer with an Active Directory domain that wants us to build their Intranet with PostgreSQL and use the user information in their Active Directory to avoid entering user information in PostgreSQL and AD. Even if we could update PostgreSQL regularly would be OK. -- Robert
Robert Fitzpatrick wrote: > Is anyone familiar with any Windows Active Directory integration for > user information. I have a customer with an Active Directory domain that > wants us to build their Intranet with PostgreSQL and use the user > information in their Active Directory to avoid entering user information > in PostgreSQL and AD. Even if we could update PostgreSQL regularly would > be OK. I'm reasonably sure (although have not tried myself) you can access Active Directory via LDAP. In the past (a few years ago), I've used available Tcl libraries for LDAP and PostgreSQL to do something similar. HTH, Joe
Couple resources that may be of value. Supposedly you can access active directory almost the same as SQL http://www.4guysfromrolla.com/webtech/041800-1.shtml SQLStmt = "SELECT cn " & _ "FROM 'LDAP://LDAPSERVER:1003/o=microsoft/ou=members' " & _ "WHERE objectClass='*'" http://msdn.microsoft.com/library/default.asp?url=/library/en-us/netdir/ adsi/active_directory.asp I am not sure what scripting language you are programming the intranet in but this example should able to do something with JAVA if not you could build the object in vb or C++ and make it soapy. Or even easier ....These guys have a product specific to your problem http://www.wedgetail.com/solution/sso.html There is an eval version... -----Original Message----- From: Robert Fitzpatrick [mailto:robert@webtent.com] Sent: Thursday, April 24, 2003 9:23 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Active Directory Is anyone familiar with any Windows Active Directory integration for user information. I have a customer with an Active Directory domain that wants us to build their Intranet with PostgreSQL and use the user information in their Active Directory to avoid entering user information in PostgreSQL and AD. Even if we could update PostgreSQL regularly would be OK. -- Robert ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)