Re: user delete problem - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: user delete problem
Date
Msg-id Pine.LNX.4.30.0105221710170.757-100000@peter.localdomain
Whole thread Raw
In response to user delete problem  (Tomasz Misterka <tomasz@hieroglif.com.pl>)
Responses password long
List pgsql-admin
Tomasz Misterka writes:

> 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?

Recreate a user with the same id and clean up the permissions.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-admin by date:

Previous
From: Sandro Dentella
Date:
Subject: ANNOUNCE: tksql (program) & sdsql (Tcl/Tk package)
Next
From: Tom Lane
Date:
Subject: Re: Cost limit.