To: pgsql-admin@postgresql.org
From: "Milen A. Radev" <milen@radev.net>
Subject: Re: Privileges to sequences?
Date: Fri, 08 Aug 2008 18:28:21 +0300
Lines: 28
Message-ID: <g7homm$r6g$1@ger.gmane.org>
References: <20F7D7F1-4939-4BE3-9116-4C82FE176E07@indiana.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
In-Reply-To: <20F7D7F1-4939-4BE3-9116-4C82FE176E07@indiana.edu>

Carol Walter написа:
> Hello,
> 
> I've had trouble several times when granting permissions on tables when 
> I had not also granted permission to the sequence.  The sequences may 
> only have select, insert, and usage privileges.  I can guess that when I 
> grant select privileges on a table, I need to grant select privileges to 
> the sequence and I can guess that if I grant insert privileges to a 
> table I need to grant the insert privilege to the sequence.  I don't 
> know when to usage and I don't know what privileges, if any, I need to 
> grant to the sequence if I'm going to give delete, update, or references 
> privileges on the tables.
[...]


Reading the documentation:
- if you only grant SELECT on the table in question - no privileges are 
needed for the linked sequence;
- for normal usage (selects, inserts, updates, deletes) - the USAGE 
privilege seems quite handy;
- when you need to grant full access to a sequence (rare case) - both 
SELECT and UPDATE;
- UPDATE, DELETE and REFERENCES privileges on the table(s) are not 
related to the privileges of the corresponding sequence;


-- 
Milen A. Radev