Skip site navigation (1) Skip section navigation (2)

Extending grant insert on tables to sequences

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: grant_seq.patch
Description: text/plain (1.6 KB)

Responses

pgsql-hackers by date

Next:From: Gregory StarkDate: 2008-05-22 20:41:07
Subject: Re: idea: storing view source in system catalogs
Previous:From: Stephen FrostDate: 2008-05-22 13:48:54
Subject: Re: pg_dump roles support

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2008-05-22 23:59:39
Subject: Re: \d+ should display the storage options for columns
Previous:From: Gregory StarkDate: 2008-05-21 20:54:48
Subject: Re: \d+ should display the storage options for columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group