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

On Sun, 7 May 2000, Peter Eisentraut wrote:

> 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.

Correct, and it also makes the assumption that the pg-admin has access to
that machine...

If I give a second user 'create database' access, how does he add auth
privileges to that database?


Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org