Martin Renters <martin@datafax.com> writes:
> Should the permissions of a deleted user get assigned to a new user
> as in the example below?
That can happen, since the default "usesysid" assignment is "max
existing usesysid + 1". If you delete the last user then their sysid
becomes a candidate for reassignment. This is not real good, but fixing
it isn't that high on the priority list (and is difficult to do unless
we take away the option of hand-assigned sysids ... otherwise we could
just have a sequence generator for sysids).
regards, tom lane