From: | Lætitia Avrot <laetitia(dot)avrot(at)gmail(dot)com> |
---|---|
To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Grant documentation about "all tables" |
Date: | 2018-12-16 15:17:45 |
Message-ID: | CAB_COdhU7e3rJjVsjAJRrC4YH2rfvBvGPtVm80reSgYw=L=m_A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
When you look at Postgres' SQL reference documentation for `GRANT`, the
`ALL TABLES` clause is explained as :
> ALL TABLES also affects views and foreign tables, just like
the specific-object GRANT command.
A colleague of mine was asking himself if it included materialized views or
not (well, yes it does).
I made that tiny patch to add materialized views to the list. It builds on
my laptop.
Then another question crossed my mind... What about partitioned tables ?
I'm pretty sure it works for them too (because they're basically tables)
but should we add them too ? I couldn't decide whether to add them too or
not so I refrain from doing it and am asking you the question.
What do you think ?
Cheers,
Lætitia
--
*Think! Do you really need to print this email ? *
*There is no Planet B.*
Attachment | Content-Type | Size |
---|---|---|
sql-grant-documentation-adding-mat-views-to-all-tables_v1.patch | application/x-patch | 894 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2018-12-16 15:39:21 | Re: Improving collation-dependent indexes in system catalogs |
Previous Message | Alvaro Herrera | 2018-12-16 15:06:16 | reorderbuffer: memory overconsumption with medium-size subxacts |