Re: [ADMIN] Privileges on sequences

2008-10-20 Thread Tom Lane
FM <[EMAIL PROTECTED]> 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

[ADMIN] Privileges on sequences

2008-10-20 Thread FM
Hello, We are using PGSQL 8.3.4 I have problem to grant privileges to a sequence. If I grant all to the user I can do something like : SELECT nextval('reflex_cited_reports_id'); SELECT nextval('reflex_cited_reports_id'); nextval -- 40442939 (1 row) BUT if I grant the same priv to the