Store database users in custom table

From: Antoine POPINEAU <apognu(at)akegroup(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Store database users in custom table
Date: 2010-03-19 23:19:10
Message-ID: 4BA4066E.4060205@akegroup.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Attachment Content-Type Size
apognu.vcf text/x-vcard 255 bytes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Rostron 2010-03-20 01:34:57 upgrade 8.3.7 to 8.3.10 combined with ownership change
Previous Message Szymon Guz 2010-03-19 19:16:15 Re: insert in function writen in pgplsql