Re: User rights - Mailing list pgsql-admin

From W. van den Akker
Subject Re: User rights
Date
Msg-id 9gi8t9$1h1n$1@news.tht.net
Whole thread Raw
In response to User rights  (Nicolas Kowalski <Nicolas.Kowalski@imag.fr>)
List pgsql-admin
A little bit off-topic but is there in the near future LDAP support
available?

gr,

Willem

"Nicolas Kowalski" <Nicolas.Kowalski@imag.fr> wrote in message
news:Pine.LNX.4.33.0106131508290.32370-100000@girose.imag.fr...
>
> Hello.
>
> We are currently running PostgreSQL 7.0.3 for our Intranet database. We
> will switch to 7.1.2 in a while.
>
> However, I just experienced strange behaviours with our current
> installation.
>
> 1) password authentification
>
> We use this method for our local network, with this line in pg_hba.conf:
>
> host all <network-address> 255.255.255.0   password passwd
>
> The "passwd" file is generated from our shadow database.
> The problem is, if a user tries to authenticate and is not in the
> pg_shadow system table but *is* in the passwd file, the access will
> always fail. If the user appears in the pg_shadow table, no problems.
>
> Is this a normal behaviour ?
>
>
> 2) User re-creation
>
> By mistake, I deleted a user (me in fact) from the pg_shadow table. I
> was the owner of several tables. As a superuser, I re-created the user,
> with the same information, sysid included. But now, I am unable to
> manage or even do some SELECT on the table I was the owner. I checked
> the relowner field in the pg_class table, and it has the value of my
> sysid....The only particular thing about these tables I am unable to
> access is that they have some access rules, setup using GRANT
> statements.
>
> My question is : why the owner of a table have all the rights on it, or
> did I missed something ?
>
> Nicolas.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl



pgsql-admin by date:

Previous
From: "Ngoc-Khoi TO"
Date:
Subject: Re: interfacing ms-access with postgresql?
Next
From: James Moore
Date:
Subject: Problems upgrading from 7.1beta4 to 7.1.0