pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: woody <woody.1q2c4a@mail.droptable.com>
To: pgsql-admin@postgresql.org
Subject: Re: unable to GRANT on sequence
Date: Fri, 3 Jun 2005 11:26:29 -0500
Message-ID: <woody.1q2c4a@mail.droptable.com> (raw)


I'm having trouble GRANTing access on sequences. I created a database
called 'asterisk' using the 'postgres' user. I then created 2 users
called 'asterisk' and 'asterisk_owner'. I created a schema called
'asterisk' and GRANTed CREATE, DROP, INSERT, UPDATE, DELETE on this
schema to 'asterisk_owner'. I signed in as 'asterisk_owner' and created
some tables with primary keys based on sequences, then GRANTed SELECT,
UPDATE, INSERT, DELETE on these tables to 'asterisk'. When I log in as
'asterisk', I can insert rows but I can't use the implied nextval(). It
says the relation <seq_name> does not exist. When I do a \dp, I can see
the sequence objects listed, but no permissions are listed. The tables
have all the expected permissions. I couldn't see anything in the
reference for the GRANT command for sequences.



--
woody
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------
 



view thread (3+ messages)  latest in thread

Message-ID: <woody.1q2c4a@mail.droptable.com>
Permalink:  ../woody.1q2c4a@mail.droptable.com/
Also on:    postgresql.org/message-id/woody.1q2c4a@mail.droptable.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: woody.1q2c4a@mail.droptable.com
  Subject: Re: unable to GRANT on sequence
  In-Reply-To: <woody.1q2c4a@mail.droptable.com>
  References: <woody.1q2c4a@mail.droptable.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox