SUM - Seeking experiences 'accessing' Microsoft Active Directory credentials from PostgreSQL, in conjunction with the sys admin / IT...
От | Greg Cocks |
---|---|
Тема | SUM - Seeking experiences 'accessing' Microsoft Active Directory credentials from PostgreSQL, in conjunction with the sys admin / IT... |
Дата | |
Msg-id | 66F6CF82BF58CE4DB4285BE816B297E8C72AE8@tribble.SMStoller.com обсуждение исходный текст |
Ответ на | Seeking experiences 'accessing' Microsoft Active Directory credentials from PostgreSQL, in conjunction with the sys admin / IT... ("Greg Cocks" <gcocks@stoller.com>) |
Список | pgsql-novice |
Regards,
GREG COCKS
Data Management Specialist / Scientist / GIS Analyst IV
gcocks@stoller.com
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell
From: Greg Cocks [mailto:gcocks@stoller.com]
Sent: Tue 2/23/2010 4:00 PM
To: pgsql-novice@postgresql.org
Cc: Pete Humphrey
Subject: [NOVICE] Seeking experiences 'accessing' Microsoft Active Directory credentials from PostgreSQL, in conjunction with the sys admin / IT...
Hello,
I have been doing some reading and working with the IT staff here to be able to get (read-only) accessibility in PostgreSQL to the Active Directory credentials for a Microsoft network – UID, fname, lname, etc (not the PWID of course!)
I would appreciate any suggestions on the most workable and dynamic approach…
My initial two thoughts were:
- Have IT write a script to dump the AS credentials as, say, a delimited text file to a (secure) location on a nightly basis (an often enough frequency for my purposes) – and have PostgreSQL dynamically link, with the right credentials, to that network location with their text file/s (including ‘recognising’ when the file/s change)
- A ‘direct’ read-only connection (without comprising the network security), but of what sort? I have no experience in how AD stores and shares its info, bit am happy to learn what is needed (IT has a lot of knowledge of course, but don’t use PostgreSQL)
Thanks in advance for any help…
Some new things to learn, always a good thing - hence what seems like a possibly vague / broad request…
----------
Regards,
Greg Cocks
Licensed Geologist, WA#415
Data Management & GIS Analyst
gcocks@stoller.com
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell
В списке pgsql-novice по дате отправления: