Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
Дата
Msg-id 2448878.1702400148@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION  (Aksel Allas <allasaksel@gmail.com>)
Список pgsql-bugs
"Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com> writes:
> What about a whole new user type:
> An 'Admin' account that isn't a super user, but just has dump/ elevated permissions /customizable.

[ shrug... ]  Maybe, but there's a mighty lot of devils hiding in
the details.  Exactly what special privileges would this user type
need?  How would we convince ourselves (and more to the point,
convince the cloud providers) that such a set of privileges is
safe to give out?  Poking holes in the privilege model is usually
a good way to create security hazards.

BTW, please keep the list cc'd.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #18241: PushTransaction may cause Standby to execute ItemIdMarkDead