From: Oleg Lebedev <olebedev@waterford.org>
To: Aasmund Midttun Godal <postgresql@envisity.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: table permissions
Date: Mon, 29 Oct 2001 18:00:42 -0700
Message-ID: <3BDDFBBA.99D3987E@waterford.org> (raw)
References: <3BDDE4F0.D5F5758E@waterford.org>
<20011029235725.552.qmail@ns.krot.org>
<3BDDF2FD.9FFF6B6C@waterford.org>
<20011030000917.28224.qmail@ns.krot.org>
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@waterford.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@godal.com - http://www.godal.com/
> +47 40 45 20 46
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: olebedev@waterford.org, postgresql@envisity.com
Subject: Re: table permissions
In-Reply-To: <3BDDFBBA.99D3987E@waterford.org>
* 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