Re: Kerberos principal to dbuser mapping - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Kerberos principal to dbuser mapping
Date
Msg-id Pine.LNX.4.44.0205161837530.1096-100000@localhost.localdomain
Whole thread Raw
In response to Re: Kerberos principal to dbuser mapping  (Daniel <dah00002000@yahoo.co.uk>)
List pgsql-hackers
Daniel writes:

> way to solve this is to use a translation method from
> principal to database users, i. e. a table.
> As the number of users of the database grows, using a
> preprocessed flat file to manage this becomes more and
> more of a problem. At that point one usually begins to
> look for the functionality of a database, and one is
> certainly close at hand :).

The server cannot access the database before you're authenticated to do
so, plus if the authentication setup is contained in the database and you
mess it up, how do you get back in?  These are the two reasons why the
information is kept in flat files.  One might come up with ways to edit
these files from within the SQL environment, which indeed is a frequently
requested feature, but for solving the problem at hand, namely the
Kerberos principal to PostgreSQL user mapping, use a flat file.  You can
probably use most of the ident.conf code.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Updated CREATE FUNCTION syntax
Next
From: "Joel Burton"
Date:
Subject: Re: Updated CREATE FUNCTION syntax