On 06/12/2012 10:00 AM, Peter Cheung wrote:
> I'm new to PostgreSQL. I installed PostgreSQL on a Windows Server
> 2008 R2 server. I have created a database and an user in Windows
> Active Directory. How can I configure that user to access that database?
By default, Windows users and PostgreSQL users are completely separate.
Use PgAdmin-III to create the user, or a "CREATE USER" command in psql. See
It is also possible to use SSPI authentication with PostgreSQL, so
PostgreSQL authenticates users against Active Directory. I haven't used
it myself. The user must still be created in PostgreSQL, SSPI just takes
care of authenticating them using their Windows credentials. See:
In response to
pgsql-admin by date
|Next:||From: Lukasz Brodziak||Date: 2012-06-12 10:23:41|
|Subject: Merging two databases|
|Previous:||From: Rural Hunter||Date: 2012-06-12 07:50:11|
|Subject: Why auto vacuum almost running all the time on one toast table?|