Re: [HACKERS] Postgres acl (fwd)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Postgres acl (fwd)
Дата
Msg-id 199801061842.NAA01656@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Postgres acl (fwd)  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: [HACKERS] Postgres acl (fwd)  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
>
> On Tue, 6 Jan 1998, Bruce Momjian wrote:
>
> > Can someone who has permission to create databases be trusted not to
> > delete others?  If we say no, how do we make sure they can change
> > pg_database rows on only databases that they own?
>
>     deleting a database is accomplished using 'drop database', no?
> Can the code for that not be modified to see whether the person dropping
> the database is the person that owns it *or* pgsuperuser?

It already does the check, but issues an SQL from the C code to delete
from pg_database.  I believe any user who can create a database can
issue the same SQL command from psql, bypassing the drop database
checks, no?

--
Bruce Momjian
maillist@candle.pha.pa.us

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Vadim B. Mikheev"
Дата:
Сообщение: Re: [HACKERS] I want to change libpq and libpgtcl for better handling of large query results
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Postgres acl (fwd)