From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
---|---|
To: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] something smells bad |
Date: | 2001-06-06 21:58:52 |
Message-ID: | Pine.BSO.4.10.10106061757200.8625-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
1) Please don't crosspost to both hackers and general
On Wed, 6 Jun 2001, [iso-8859-1] Martn Marqus wrote:
> ERROR: carrera_id_curso_seq.nextval: you don't have permissions to set
> sequence carrera_id_curso_seq
Because of the way postgres works, you need to grant write permission on
the carrera_id_curso_seq for your inserts to succeed.
> The rules are OK as for what I see, but the other user insert even though the
> user mariana has ALL permissions on the views (all the views) through her
> group (webunl_admin)
>
>
> webunl=> select * from pg_group;
> groname | grosysid | grolist
> --------------+----------+------------------
> webunl_admin | 500 | {1015,1005,1014}
> (1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2001-06-06 22:14:54 | Re: [HACKERS] something smells bad |
Previous Message | Stephan Szabo | 2001-06-06 21:58:09 | Re: [SQL] maximum number of rows in table - what about oid limits? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-06 22:10:00 | Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal |
Previous Message | Joe Conway | 2001-06-06 21:45:57 | Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal |