Re: Permission; select currval('seq')

From: Ivan K <ivan_521521(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: aklaver(at)comcast(dot)net
Subject: Re: Permission; select currval('seq')
Date: 2010-01-02 23:57:40
Message-ID: 482009.43147.qm@web65505.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes, that was the ticket; the commands I needed to
execute are as follows:

GRANT UPDATE ON bla_bla_id_seq TO GROUP test_group_01;
GRANT SELECT ON bla_bla_id_seq TO GROUP test_group_01;
GRANT INSERT ON bla_bla_id_seq TO GROUP test_group_01;

Thanks!

--- On Sat, 1/2/10, Adrian Klaver <aklaver(at)comcast(dot)net> wrote:
>
>
>
> From here;
> http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
>
> GRANT USAGE is for procedural languages and SCHEMA.
>
> You will need to use the GRANT SELECT|INSERT ON  TABLE
> bla_bla_id_seq form.
> Sequences being a type of table and not having their own
> GRANT form until later
> versions.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-01-03 00:20:40 Re: Permission; select currval('seq')
Previous Message Tom Lane 2010-01-02 23:18:14 Re: Permission; select currval('seq')