Postgres Pro
Downloads
Home   >   mailing lists

Re: Granting permission on a sequence to a group - Mailing list pgsql-novice

From Walker, Jed S
Subject Re: Granting permission on a sequence to a group
Date
Msg-id 41669DC6FE3B80449A33A4DD46DB370A09E7EAF3@entcoexch15.broadband.att.com
Whole thread Raw
In response to Granting permission on a sequence to a group  ("Walker, Jed S" <Jed_Walker@cable.comcast.com>)
List pgsql-novice
Tree view

I found a note in a book that states that using "nextval" can't be done with only select privileges, but it doesn't say what else is needed. Can someone tell me (hopefully I find it eventually)?

_____________________________________________
From:   Walker, Jed S 
Sent:   Thursday, April 21, 2005 3:50 PM
To:     'pgsql-novice@postgresql.org'
Subject:        Granting permission on a sequence to a group

Hi,

I have a sequence seq_page owned by user vrnsys. Vrnsys has granted "select" on seq_page to group vrn_admin. vrn_admin group has had user vrngui added to it, but vrngui is not able to access the sequence (permission denied for sequence seq_page).

1. Any ideas why this isn't working?

Thanks in advance,

      Jed S. Walker

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: Disk full problem
Next
From: "Walker, Jed S"
Date:
Subject: Authorized privileges when calling a procedure