Re: CREATE DATABASE WITH OWNER '??';

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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org