Re: add \dpS to psql
От | Nathan Bossart |
---|---|
Тема | Re: add \dpS to psql |
Дата | |
Msg-id | 20221209184411.GB59417@nathanxps13 обсуждение исходный текст |
Ответ на | Re: add \dpS to psql (Nathan Bossart <nathandbossart@gmail.com>) |
Ответы |
Re: add \dpS to psql
|
Список | pgsql-hackers |
On Fri, Dec 09, 2022 at 10:40:55AM -0800, Nathan Bossart wrote: > On Fri, Dec 09, 2022 at 01:36:03PM +0900, Michael Paquier wrote: >> On Thu, Dec 08, 2022 at 09:15:03AM -0800, Nathan Bossart wrote: >>> The main idea behind this work is breaking out privileges into more >>> granular pieces. If I want to create a role that only runs VACUUM on some >>> tables on the weekend, why ѕhould I have to also give it the ability to >>> ANALYZE, REFRESH, CLUSTER, and REINDEX? IMHO we should really let the user >>> decide what set of privileges makes sense for their use-case. I'm unsure >>> the grouping all these privileges together serves much purpose besides >>> preserving ACL bits. >> >> Hmm. I'd like to think that we should keep a frugal mind here. More >> bits are now available, but it does not strike me as a good idea to >> force their usage more than necessary, so grouping all these no-quite >> DDL commands into the same bag does not sound that bad to me. > > Okay, it seems I am outnumbered. I will work on updating the patch to add > an ACL_MAINTAIN bit and a pg_maintain_all_tables predefined role. Any thoughts on $SUBJECT? -- Nathan Bossart Amazon Web Services: https://aws.amazon.com
В списке pgsql-hackers по дате отправления: