[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] table permissions
From:       "Aasmund Midttun Godal" <postgresql () envisity ! com>
Date:       2001-10-30 3:20:49
[Download RAW message or body]

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@waterford.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@postgresql.org so that your
> message can get through to the mailing list cleanly

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


[prev in list] [next in list] [prev in thread] [next in thread]