Re: table permissions

I have 3 users in the database: postgres, oleg, and boss. boss is the superuser and has permissions to modify both original and referenced table.
However, when I am logged in as boss, it won't let me modify the original ('set') table unless user oleg (!!!!) has update permissions on the
referenced table ('activity'). Now I understand that I didn't have this problem before, because I just recently created this superuser boss.

Another thing, I just noticed is that the tables I mentioned do not have permissions defined for user postgres. All the other tables in my database
do have those permissions set. Can this be the cause of the problem?
thanks,

Oleg

Aasmund Midttun Godal wrote:

> The problem is that updating/inserting/deleting a row which references another table requires all permissions on that table. This has been fixed.
>
> Regards,
>
> Aasmund.
>
> On Mon, 29 Oct 2001 17:23:25 -0700, Oleg Lebedev <olebedev(at)waterford(dot)org> wrote:
> > I am using v7.1.2
> > I guess, this might be a table locking problem, but I don't have any transactions currently running.
> >
> > A couple of days ago I did a restore of 'set' table from a dump file, and it didn't go too well - I
> > had a couple of problems. I don't know if it's relevant, but smth's telling me that it is.
> >
> > Oleg
> >
> > Aasmund Midttun Godal wrote:
> >
> >
>
> Aasmund Midttun Godal
>
> aasmund(at)godal(dot)com - http://www.godal.com/
> +47 40 45 20 46