On 03/16/2012 08:00 AM, salah jubeh wrote:
Hello Adrian,
Sorry, I was not clear.
what I meant is that.
GRANT INSERT, UPDATE ON tablenaem TO USER; -- leads to GRANT ALL ON
TABLE tablename_colname_seq TO USER
CCing the list.
Still not following.
What version of Postgres are you using?
Using 9.0.7 here I get:
test=> CREATE TABLE ser_test(id serial);
public | ser_test | table | aklaver
public | ser_test_id_seq | sequence | aklaver
test=> \dp ser_test
Access privileges
Schema | Name | Type | Access privileges | Column access privileges
--------+----------+-------+-------------------+--------------------------
public | ser_test | table | |
(1 row)
test=> \dp ser_test_id_seq
Access privileges
Schema | Name | Type | Access privileges | Column
access privileges
--------+-----------------+----------+-------------------+--------------------------
public | ser_test_id_seq | sequence |
GRANT INSERT, UPDATE ON table ser_test to sales;
GRANT
test=> \dp ser_test
Access privileges
Schema | Name | Type | Access privileges | Column access
privileges
--------+----------+-------+-------------------------+--------------------------
public | ser_test | table | aklaver=arwdDxt/aklaver+|
| | | sales=aw/aklaver |
test=> \dp ser_test_id_seq
Access privileges
Schema | Name | Type | Access privileges | Column
access privileges
--------+-----------------+----------+-------------------+--------------------------
public | ser_test_id_seq | sequence | |
Regards
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
