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

From Tom Lane
Subject Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
Date
Msg-id 2448878.1702400148@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18242: pg_dump with non-superuser from pg14 to pg15 fails on ALTER FUNCTION
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #18241: PushTransaction may cause Standby to execute ItemIdMarkDead