Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE DATABASE WITH OWNER '??'; - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: CREATE DATABASE WITH OWNER '??';
Date
Msg-id Pine.LNX.4.21.0005070143500.502-100000@localhost.localdomain
Whole thread Raw
In response to CREATE DATABASE WITH OWNER '??';  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: CREATE DATABASE WITH OWNER '??';  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: CREATE DATABASE WITH OWNER '??';  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
Tree view 
The Hermit Hacker writes:

> For instance, if I go into pg_hba.conf and make a database 'passwd' auth
> only, then anyone that has a userid/passwd can connect to that database,
> regardless ...

You need to make a separate password file for each database and then write
`passwd my_pw_file' in pg_hba.conf. Should be documented somewhere
there. Hmm, then you can't change your password with ALTER USER any
more. Bummer.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: You're on SecurityFocus.com for the cleartext passwords.
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_group_name_index corrupt?