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.0005091533090.387-100000@localhost.localdomain
Whole thread Raw
In response to Re: CREATE DATABASE WITH OWNER '??';  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: CREATE DATABASE WITH OWNER '??';  (The Hermit Hacker <scrappy@hub.org>)
Re: CREATE DATABASE WITH OWNER '??';  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
The Hermit Hacker writes:

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

There are no privileges on databases per se. There are only host-based
access privileges that may apply to all or some databases.

The difficulty with putting the control over this into the SQL environment
is two-fold:

1) You have a bootstrapping problem, because how are you going to set
these privileges if you can't connect?

2) You don't necessarily want to start up a new backend for every rogue
connection attempt.

So we're mostly stuck with what we have.


-- 
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: Peter Eisentraut
Date:
Subject: Re: Re: Ready to release?
Next
From: Peter Eisentraut
Date:
Subject: Re: logging problem ... ?