user delete problem

From: Tomasz Misterka <tomasz(at)hieroglif(dot)com(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: user delete problem
Date: 2001-05-22 08:18:32
Message-ID: Pine.LNX.4.21.0105221005010.1752-100000@www.netla.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hitesh Shah 2001-05-22 12:02:34 Need help
Previous Message Andre Schubert 2001-05-22 07:11:18 Postgres 7.0.3 Dying