From: Craig Ringer <ringerc@ringerc.id.au>
To: Peter Cheung <Pcheung@sfcu.org>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: How to setup PostgreSQL using Windows Authentication?
Date: Tue, 12 Jun 2012 16:11:26 +0800
Message-ID: <4FD6F9AE.9000203@ringerc.id.au> (raw)
In-Reply-To: <583566AE01BD5948A12C964BD739A9A24686BA6A@HARRY.sfcu.intr>
References: <583566AE01BD5948A12C964BD739A9A24686BA6A@HARRY.sfcu.intr>
On 06/12/2012 10:00 AM, Peter Cheung wrote:
>
> Hi,
>
> 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
http://www.postgresql.org/docs/9.1/static/user-manag.html
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:
http://www.postgresql.org/docs/9.1/static/auth-methods.html
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, Pcheung@sfcu.org
Subject: Re: How to setup PostgreSQL using Windows Authentication?
In-Reply-To: <4FD6F9AE.9000203@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox