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: | Whole Thread | Raw Message | 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
-----------------------------------------------------------------
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 |
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 |