From: | "Aasmund Midttun Godal" <postgresql(at)envisity(dot)com> |
---|---|
To: | olebedev(at)waterford(dot)org |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: table permissions |
Date: | 2001-10-30 03:20:49 |
Message-ID: | 20011030032049.7343.qmail@ns.krot.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I don't really know a lot about these issues. However another problem I used to have (I have just avoided it for the time being, and I am getting back to it!) is corrupted users, have you messed around with pg_hba.conf? perhaps it is a problem with this.
I apologize, but I don't really know. Hope someone else can help you!
Regards,
Aasmund.
On Mon, 29 Oct 2001 18:00:42 -0700, Oleg Lebedev <olebedev(at)waterford(dot)org> wrote:
> 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:
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
Aasmund Midttun Godal
aasmund(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46
From | Date | Subject | |
---|---|---|---|
Next Message | sharmad | 2001-10-30 10:00:20 | error in postgresql |
Previous Message | Oleg Lebedev | 2001-10-30 01:00:42 | Re: table permissions |