From: | Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | User rights |
Date: | 2001-06-13 13:33:26 |
Message-ID: | Pine.LNX.4.33.0106131508290.32370-100000@girose.imag.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David M. Richter | 2001-06-13 14:09:31 | Posgres 7.1.2 and IRIX 6.4 |
Previous Message | DHSC Webmaster | 2001-06-13 13:32:24 | performance issues |