From: FM <dist-list@LEXUM.UMontreal.CA>
To: pgsql-admin@postgresql.org
Subject: Privileges on sequences
Date: Mon, 20 Oct 2008 15:58:45 -0400
Message-ID: <48FCE2F5.5090902@lexum.umontreal.ca> (raw)
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 group (that include the user) :
SELECT nextval('reflex_cited_reports_id');
ERROR: permission denied for sequence reflex_cited_reports_id
some info :
canlii_integration_tests=# SELECT nextval('reflex_cited_reports_id');
nextval
----------
40442939
(1 row)
canlii_integration_tests=# SELECT * from pg_roles where
rolname='soft_reflex_externe';
rolname | rolsuper | rolinherit | rolcreaterole |
rolcreatedb | rolcatupdate | rolcanlogin | rolconnlimit | rolpassword |
rolvaliduntil | rolconfig | oid
---------------------+----------+------------+---------------+-------------+--------------+-------------+--------------+-------------+---------------+-----------+-----------
soft_reflex_externe | f | f | f |
f | f | t | -1 | ******** |
infinity | | 820769731
(1 row)
canlii_integration_tests=# SELECT * from pg_group where
groname='reflex_lecteurs';
groname | grosysid |
grolist
-----------------+----------+-------------------------------------------------------------------
reflex_lecteurs | 16431 |
{16400,16409,16417,16418,16424,16434,16479,16499,16500,820769731}
(1 row)
Is it a bug ? Or am i doing something wrong
Regards,
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dist-list@LEXUM.UMontreal.CA
Subject: Re: Privileges on sequences
In-Reply-To: <48FCE2F5.5090902@lexum.umontreal.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox