Re: User rights

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

In response to

  • User rights at 2001-06-13 13:33:26 from Nicolas Kowalski

Responses

Browse pgsql-admin by date

  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