On Tue, 30 Jul 2002, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > First and foremost in my mind ... how do you have two users in the system > > with seperate passwords? ... > > since as soon as there are two 'bruce' users, only one can have a password > > Uh, we've *never* supported "two bruce users" ... users have always been > installation-wide. I am not sure what the notion of a database-owning > user means if user names are not of wider scope than databases.
Sorry, you mis-understand here ... pg_user/shadow only has one bruce user in it ... but the way it was up until now, with the password file in pg_hba.conf, I could assign bruce with a different password for database1 vs database2 ... effectively, have 'two bruce users' ... ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
