Extending grant insert on tables to sequences - Mailing list pgsql-patches

From Jaime Casanova
Subject Extending grant insert on tables to sequences
Date
Msg-id c2d9e70e0805221118x1411e00crd7d4aae7e6e4ea3d@mail.gmail.com
Whole thread Raw
Responses Re: Extending grant insert on tables to sequences
List 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

pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Re: \d+ should display the storage options for columns
Next
From: Alvaro Herrera
Date:
Subject: Re: \d+ should display the storage options for columns