Message-ID: <4BA4066E.4060205@akegroup.org>
Date: Sat, 20 Mar 2010 00:19:10 +0100
From: Antoine POPINEAU <apognu@akegroup.org>
Organization: AKE Group
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.8) Gecko/20100227 Lightning/1.0b1 Thunderbird/3.0.3
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Store database users in custom table
Content-Type: multipart/signed; protocol="application/pkcs7-signature";
	micalg=sha1; boundary="------------ms070003040605040403050409"

This is a cryptographically signed message in MIME format.

--------------ms070003040605040403050409
Content-Type: multipart/mixed;
 boundary="------------040100060804010000050606"

This is a multi-part message in MIME format.
--------------040100060804010000050606
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi,

I am developping a Java application, and using a PostgreSQL backend=20
database. Theorically, there might be lots of users, each with=20
potentially different permissions over the different tables.

I could add those user to the database with a classic CREATE USER, but=20
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=20
possibility to tell Postgres to fetch user logins and passwords in a=20
custom table (perhaps respecting a certain schema) instead of the=20
default location?

Thank you.

Antoine POPINEAU.

--------------040100060804010000050606
Content-Type: text/x-vcard; charset=utf-8;
 name="apognu.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
 filename="apognu.vcf"

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


--------------040100060804010000050606--

--------------ms070003040605040403050409
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIHEDCC
A4QwggJsoAMCAQICAUgwDQYJKoZIhvcNAQEFBQAwVjESMBAGA1UEChMJQUtFIEdyb3VwMQsw
CQYDVQQGEwJGUjESMBAGA1UEAxMJQUtFIEdyb3VwMR8wHQYJKoZIhvcNAQkBFhBha2VAYWtl
Z3JvdXAub3JnMB4XDTEwMDEyOTE4MjUwNVoXDTExMDEyOTE4MjUwNVowgYUxEjAQBgNVBAoT
CUFLRSBHcm91cDELMAkGA1UEBhMCRlIxGTAXBgNVBAMTEEFudG9pbmUgUE9QSU5FQVUxIjAg
BgkqhkiG9w0BCQEWE2Fwb2dudUBha2Vncm91cC5vcmcxETAPBgNVBAQTCFBPUElORUFVMRAw
DgYDVQQqEwdBbnRvaW5lMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1FXHu+4g
W/bSoZcLCB9fCiGzZYNdclsuk5YDAFBOULVbUYLMbYzgmWRa9yTt7mOioNK+Hcp4aBBtyo2J
2dvWfp9ISR9aGrIdaqPjplBcQaL4TpdSXueXQi7D8gSsNaW+w0oYq0VESOm/CnfDsNxYvcyF
6LQY6aPNLoHxbbVhGtaXuE1XKiXh5jrpPzxhEXsqq9Hc9vgysLw0keBeh+u0fJWupFw/Vyci
lrqWqZbIT5tgdtTSqQ1Iz/z63iKiWTzD9oi9SOl3QkPekHgyvWf4FTfqdmP8CAAxuGh8ptdo
dAe/mRJtifHDHSaadkefDyIJP7lyjgMeX9EY+UgIj95GkwIDAQABoy0wKzAJBgNVHRMEAjAA
MBEGCWCGSAGG+EIBAQQEAwIEsDALBgNVHQ8EBAMCBPAwDQYJKoZIhvcNAQEFBQADggEBAFsT
d7zW9MhCPTMrNuEyR/acA7F6iSHxdyUqMlXjap/+1H7JNLxNkN9D6kaRgTMhAEu96b08d9Z/
3/8GyannBoraKbN44MWCKzeyxXHkGHFbIizUTYNcoGYufqlmam3Wvs8VFKUWrAlCq1BGuCEQ
rUVTwshV61QH0CXJVn+GFRiNeoh1qr3XpLUhNWzagxILG2vv9gXFnw7JNFMx2zOyOTFRRBGw
hjTvgjYTMGR48Vyl557aTF4rtxntcvTjgUJjgEvwA6s/Kx3wlpzxX4tEOzPDgIKsrTOQaJp6
LHNKNRH0W3ssDiH/a3/GDwCLfqJJZImnlpt3ffklrQznYgbBK9kwggOEMIICbKADAgECAgFI
MA0GCSqGSIb3DQEBBQUAMFYxEjAQBgNVBAoTCUFLRSBHcm91cDELMAkGA1UEBhMCRlIxEjAQ
BgNVBAMTCUFLRSBHcm91cDEfMB0GCSqGSIb3DQEJARYQYWtlQGFrZWdyb3VwLm9yZzAeFw0x
MDAxMjkxODI1MDVaFw0xMTAxMjkxODI1MDVaMIGFMRIwEAYDVQQKEwlBS0UgR3JvdXAxCzAJ
BgNVBAYTAkZSMRkwFwYDVQQDExBBbnRvaW5lIFBPUElORUFVMSIwIAYJKoZIhvcNAQkBFhNh
cG9nbnVAYWtlZ3JvdXAub3JnMREwDwYDVQQEEwhQT1BJTkVBVTEQMA4GA1UEKhMHQW50b2lu
ZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBANRVx7vuIFv20qGXCwgfXwohs2WD
XXJbLpOWAwBQTlC1W1GCzG2M4JlkWvck7e5joqDSvh3KeGgQbcqNidnb1n6fSEkfWhqyHWqj
46ZQXEGi+E6XUl7nl0Iuw/IErDWlvsNKGKtFREjpvwp3w7DcWL3Mhei0GOmjzS6B8W21YRrW
l7hNVyol4eY66T88YRF7KqvR3Pb4MrC8NJHgXofrtHyVrqRcP1cnIpa6lqmWyE+bYHbU0qkN
SM/8+t4iolk8w/aIvUjpd0JD3pB4Mr1n+BU36nZj/AgAMbhofKbXaHQHv5kSbYnxwx0mmnZH
nw8iCT+5co4DHl/RGPlICI/eRpMCAwEAAaMtMCswCQYDVR0TBAIwADARBglghkgBhvhCAQEE
BAMCBLAwCwYDVR0PBAQDAgTwMA0GCSqGSIb3DQEBBQUAA4IBAQBbE3e81vTIQj0zKzbhMkf2
nAOxeokh8XclKjJV42qf/tR+yTS8TZDfQ+pGkYEzIQBLvem9PHfWf9//Bsmp5waK2imzeODF
gis3ssVx5BhxWyIs1E2DXKBmLn6pZmpt1r7PFRSlFqwJQqtQRrghEK1FU8LIVetUB9AlyVZ/
hhUYjXqIdaq916S1ITVs2oMSCxtr7/YFxZ8OyTRTMdszsjkxUUQRsIY074I2EzBkePFcpeee
2kxeK7cZ7XL044FCY4BL8AOrPysd8Jac8V+LRDszw4CCrK0zkGiaeixzSjUR9Ft7LA4h/2t/
xg8Ai36iSWSJp5abd335Ja0M52IGwSvZMYIDHjCCAxoCAQEwWzBWMRIwEAYDVQQKEwlBS0Ug
R3JvdXAxCzAJBgNVBAYTAkZSMRIwEAYDVQQDEwlBS0UgR3JvdXAxHzAdBgkqhkiG9w0BCQEW
EGFrZUBha2Vncm91cC5vcmcCAUgwCQYFKw4DAhoFAKCCAZgwGAYJKoZIhvcNAQkDMQsGCSqG
SIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTAwMzE5MjMxOTEwWjAjBgkqhkiG9w0BCQQxFgQU
QZDnI9KqcfqdZI+NYnc5kKNL9TMwXwYJKoZIhvcNAQkPMVIwUDALBglghkgBZQMEAQIwCgYI
KoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqG
SIb3DQMCAgEoMGoGCSsGAQQBgjcQBDFdMFswVjESMBAGA1UEChMJQUtFIEdyb3VwMQswCQYD
VQQGEwJGUjESMBAGA1UEAxMJQUtFIEdyb3VwMR8wHQYJKoZIhvcNAQkBFhBha2VAYWtlZ3Jv
dXAub3JnAgFIMGwGCyqGSIb3DQEJEAILMV2gWzBWMRIwEAYDVQQKEwlBS0UgR3JvdXAxCzAJ
BgNVBAYTAkZSMRIwEAYDVQQDEwlBS0UgR3JvdXAxHzAdBgkqhkiG9w0BCQEWEGFrZUBha2Vn
cm91cC5vcmcCAUgwDQYJKoZIhvcNAQEBBQAEggEAi7TroyzetUKfc36So25t52mRCTnqTNj5
DBeFEng61dPAdcpMI0SWl72Z0vnIyBv+mOTSlacckPhEdFXzwqCAmt5cHwABZ5HzLzkJnsYh
c6RwE1TIV138Cng+1IrUVFbAClkPyv2mvuZdllMpuvSfWCDXVniks39x+1BUratEz/4ihtuX
8o1cwU5Jd+25U5vVqkPhf+psuAb8BGmJ1YWPMoTalnPxVPW03F9o6bzBpr7ddAms8slxuk+E
Eci4PH42B+b370hfLB1Ps4ckKP++MFNJU4PdDTmJhpFUc6POVcl8QZnHt9diluRsmIFlg1a1
3rtRAX+TztO4oonHiXM0GgAAAAAAAA==
--------------ms070003040605040403050409--