Re: Permission; select currval('seq') - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Permission; select currval('seq')
Date
Msg-id 201001021620.41365.aklaver@comcast.net
Whole thread Raw
In response to Permission; select currval('seq')  (Ivan K <ivan_521521@yahoo.com>)
List 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@comcast.net

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Permission; select currval('seq')
Next
From: David Fetter
Date:
Subject: Deadlocks On Demand