tables, permissions, sequences

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: tables, permissions, sequences
Date: 2001-06-06 13:21:00
Message-ID: 01060616210001.29859@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

I have a database with a bunch of tables with owner martin. There are a bunch
of views and rules also owned by martin (me! :-) ).
There is a group admin_users which has ALL privileges over the views. When
ever I try to do an insert on the view (the rule executes a few inserts) I
get this error:

ERROR: carrera_id_curso_seq.nextval: you don't have permissions to set
sequence carrera_id_curso_seq

What's wrong?
I'm on Postgres 7.1.1.

Saludos... :-)

--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2001-06-06 13:23:03 Re: pg_dump problem
Previous Message Mathieu Arnold 2001-06-06 13:16:29 Re: pg_dump problem

Browse pgsql-sql by date

  From Date Subject
Next Message Guru Prasad 2001-06-06 13:22:31 Large Objects - lo_export
Previous Message tjk@tksoft.com 2001-06-06 13:04:32 Re: Large Objects - lo_export