I need to have members of a particular user
group insert rows into a table and then determine the
recently inserted statement's primary key that was
created from a sequence with the currval() function:
select currval('bla_bla_id_seq');
I have been unable to set these permissions.
I am using 8
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 wrote:
>
>
