Re: serial- sequence priveleges

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: salah jubeh <s_jubeh(at)yahoo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: serial- sequence priveleges
Date: 2012-03-16 15:35:53
Message-ID: 4F635DD9.6060503@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Another thought you do not happen to have DEFAULT PRIVILEGES set up for
sequences:

http://www.postgresql.org/docs/9.0/interactive/sql-alterdefaultprivileges.html

In psql \ddp will list them.

>
> Regards
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-03-16 16:18:18 Re: Problem for restoure data base Postgre
Previous Message Adrian Klaver 2012-03-16 15:20:25 Re: serial- sequence priveleges