Re: CREATE DATABASE WITH OWNER '??';

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: CREATE DATABASE WITH OWNER '??';
Дата
Msg-id Pine.LNX.4.21.0005091533090.387-100000@localhost.localdomain
обсуждение исходный текст
Ответ на Re: CREATE DATABASE WITH OWNER '??';  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: CREATE DATABASE WITH OWNER '??';  (The Hermit Hacker <scrappy@hub.org>)
Re: CREATE DATABASE WITH OWNER '??';  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Re: Ready to release?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: logging problem ... ?