pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nicolas Kowalski <Nicolas.Kowalski@imag.fr>
Cc: pgsql-admin@postgresql.org
Subject: Re: User rights
Date: Wed, 13 Jun 2001 10:24:43 -0400
Message-ID: <26256.992442283@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.33.0106131508290.32370-100000@girose.imag.fr>
References: <Pine.LNX.4.33.0106131508290.32370-100000@girose.imag.fr>

Nicolas Kowalski <Nicolas.Kowalski@imag.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



view thread (8+ messages)  latest in thread

Message-ID: <26256.992442283@sss.pgh.pa.us>
Permalink:  ../26256.992442283@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/26256.992442283@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, Nicolas.Kowalski@imag.fr
  Subject: Re: User rights
  In-Reply-To: <26256.992442283@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox