In this case the user has global authorization for the given role. Authorization through Access Control Lists is described below.
UPDATE users SET disabled=0, disabled_at=NULL WHERE disabled !=0 AND name = '<username>';
Users may only be reactivated, if no other active user with that name (case-insensitive) exists. Otherwise a duplicate key value violation will be thrown.