| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Daniel Kalchev <daniel(at)digsys(dot)bg> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: DROP USER weirdness in 7.2.1 |
| Date: | 2002-10-15 18:54:03 |
| Message-ID: | Pine.LNX.4.44.0210152033280.928-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Daniel Kalchev writes:
> One would normally expect, that when DROP USER someuser is issued, all
> associated data structures will be readjusted, especially ownership and access
> rights.
Perhaps, but the documentation states otherwise.
> There is no way to remove rights of this 'user' 98 using REVOKE etc.
>
> Perhaps full dump/reload will remove the rights, because that user will not be
> found, but restore may fail due to the error conditions.
>
> Any resolution for this?
Recreate the user with the given ID and drop the objects manually.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-10-15 18:54:04 | Re: oid2name and relfilenode |
| Previous Message | Peter Eisentraut | 2002-10-15 18:53:50 | Re: orderRules() now a bad idea? |