| From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
|---|---|
| To: | pgsql-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Extending grant insert on tables to sequences |
| Date: | 2008-05-22 18:18:24 |
| Message-ID: | c2d9e70e0805221118x1411e00crd7d4aae7e6e4ea3d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Hi,
The idea of this patch is to avoid the need to make explicit grants on
sequences owned by tables.
This patch make:
- GRANT INSERT ON TABLE extend to GRANT USAGE ON SEQUENCE (currval, nextval)
- GRANT UPDATE ON TABLE extend to GRANT UPDATE ON SEQUENCE (nextval, setval)
- GRANT SELECT ON TABLE extend to GRANT SELECT ON SEQUENCE (currval)
comments?
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 087171157
| Attachment | Content-Type | Size |
|---|---|---|
| grant_seq.patch | text/plain | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-05-22 20:41:07 | Re: idea: storing view source in system catalogs |
| Previous Message | Stephen Frost | 2008-05-22 13:48:54 | Re: pg_dump roles support |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-05-22 23:59:39 | Re: \d+ should display the storage options for columns |
| Previous Message | Gregory Stark | 2008-05-21 20:54:48 | Re: \d+ should display the storage options for columns |