Re: serial- sequence priveleges

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.klaver@gmail.com