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

Which GRANTS are needed on a Sequnce?

From: Dani Oderbolz <oderbolz(at)ecologic(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Which GRANTS are needed on a Sequnce?
Date: 2003-06-27 14:43:49
Message-ID: 3EFC5825.8040904@ecologic.de (view raw or flat)
Thread:
Lists: pgsql-novice
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)

Cheers,
Dani





Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2003-06-27 14:50:45
Subject: Re: missing postmaster.conf
Previous:From: Nabil SayeghDate: 2003-06-27 13:55:35
Subject: Re: Probably a stupid question

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