From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Dani Oderbolz <oderbolz(at)ecologic(dot)de> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Which GRANTS are needed on a Sequnce? |
Date: | 2003-06-27 14:59:56 |
Message-ID: | 20030627145956.GD15269@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Fri, Jun 27, 2003 at 16:43:49 +0200,
Dani Oderbolz <oderbolz(at)ecologic(dot)de> wrote:
> Hi all,
> I just created a Sequence S for User A.
> User B has the USAGE Privilage in Schema A.
> I granted SELECT On S TO B.
> But this does not seem to be enough to use the Sequcence,
> postgres claims:
> [1] ERROR: S.nextval: you don't have permissions to set sequence S
> So I granted ALL ON S TO B
> which works fine.
> What are the minimal grants neeeded? (And where is it documented,
> the reference of 7.3.3 sais nothing about Sequences)
You need to grant update access to the sequence.
This is documented at:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-grant.html
Look under what access is granted by update.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-06-27 15:15:06 | Re: Address Table |
Previous Message | Tom Lane | 2003-06-27 14:50:45 | Re: missing postmaster.conf |