Re: weird problem with grants

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Dick Kniep <dick(at)kniep(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: weird problem with grants
Date: 2005-10-10 21:31:38
Message-ID: 1128979898.29961.85.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2005-10-10 at 16:37, Dick Kniep wrote:
> Hi list,
>
> I have a weird problem with grants. Probably I am forgetting something, but I
> simply don't understand it.
>
> We have a user 'x' that is member of group 'a'
> there is a sequence where
> Grant all on table schema.sequence to group 'a'
>
> But still I get a permission denied when I try to access the sequence as user
> 'x'.

Did you grant permission on the sequence as well?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dick Kniep 2005-10-10 21:37:18 weird problem with grants
Previous Message Tom Lane 2005-10-10 21:28:17 Re: Duplicate primary keys/rows