From: Antoine POPINEAU <apognu@akegroup.org>
To: pgsql-admin@postgresql.org
Subject: Store database users in custom table
Date: Sat, 20 Mar 2010 00:19:10 +0100
Message-ID: <4BA4066E.4060205@akegroup.org> (raw)
Hi,
I am developping a Java application, and using a PostgreSQL backend
database. Theorically, there might be lots of users, each with
potentially different permissions over the different tables.
I could add those user to the database with a classic CREATE USER, but
that doesn't seem efficient to me, since I've already got a custom table
with users data and, amongst others, password.
So my question is simple (the answer might not be, though): is there a
possibility to tell Postgres to fetch user logins and passwords in a
custom table (perhaps respecting a certain schema) instead of the
default location?
Thank you.
Antoine POPINEAU.
Attachments:apognu.vcf (text/x-vcard, 253B) download
begin:vcard
fn:Antoine POPINEAU
n:POPINEAU;Antoine
org:Antoine POPINEAU
adr:;;24 rue du Berry;Chevilly-Larue;;94550;France
email;internet:apognu@akegroup.org
tel;cell:+33 6 84 83 01 34
x-mozilla-html:FALSE
url:http://www.apognu.net
version:2.1
end:vcard
smime.p7s (application/pkcs7-signature, 2.6K) download
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: apognu@akegroup.org
Subject: Re: Store database users in custom table
In-Reply-To: <4BA4066E.4060205@akegroup.org>
* 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