From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: User rights |
Date: | 2001-06-13 14:24:43 |
Message-ID: | 26256.992442283@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr> writes:
> 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.
If you're not in pg_shadow you are not a postgres user. Bogus
entries in password files won't help you.
> 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...
Hmm, that should work, if you're sure you got the right sysid. Also
check to make sure there is only one row in pg_shadow with that sysid.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-13 14:29:33 | Re: performance issues |
Previous Message | David M. Richter | 2001-06-13 14:09:31 | Posgres 7.1.2 and IRIX 6.4 |