user delete problem - Mailing list pgsql-admin

From Tomasz Misterka
Subject user delete problem
Date
Msg-id Pine.LNX.4.21.0105221005010.1752-100000@www.netla.pl
Whole thread Raw
Responses Re: user delete problem  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Hi,

I've got problem with user.
When I'm delete'ing user from postgreSQL, which has permissions to many
databases, hi leave after himself UID.

the result is:

namebase=# \z
      Access permissions for database "namebase"
 Relation | Access permissions
----------+-------------------------------------------
 dbsx1 | {"=","1118=r","user2=arw","user3=r"}
 dbsx2   | {"=","1118=r","user2=arw","user3=r"}


1118 is a result of deleting user "user1" - this time it's oly read
permission, but how to clean that?

With Regards
Tomasz Misterka


pgsql-admin by date:

Previous
From: Andre Schubert
Date:
Subject: Postgres 7.0.3 Dying
Next
From: Peter Eisentraut
Date:
Subject: Re: cannot connect using terminal nor pgaccess