Re: Permission; select currval('seq')

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: Ivan K <ivan_521521(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Permission; select currval('seq')
Date: 2010-01-03 00:20:40
Message-ID: 201001021620.41365.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday 02 January 2010 3:57:40 pm Ivan K wrote:
> 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!
>

For completeness if you only need select currval() permissions, then you only
need to GRANT SELECT.

--
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jamie Kahgee 2010-01-03 01:35:48 split to table by space
Previous Message Ivan K 2010-01-02 23:57:40 Re: Permission; select currval('seq')