FM <dist-list@xxxxxxxxxxxxxxxxxx> writes: > BUT if I grant the same priv to the group (that include the user) : > SELECT nextval('reflex_cited_reports_id'); > ERROR: permission denied for sequence reflex_cited_reports_id Works for me ... regression=# create sequence s1; CREATE SEQUENCE regression=# create user u1; CREATE ROLE regression=# \c - u1 You are now connected to database "regression" as user "u1". regression=> select nextval('s1'); ERROR: permission denied for sequence s1 regression=> \c - postgres You are now connected to database "regression" as user "postgres". regression=# create group g1; CREATE ROLE regression=# grant g1 to u1; GRANT ROLE regression=# grant all on sequence s1 to g1; GRANT regression=# \c - u1 You are now connected to database "regression" as user "u1". regression=> select nextval('s1'); nextval --------- 1 (1 row) regression=> regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin