Change Email

How to change a portal user's email address

There are three tables in the database that have to be updated to change a user's email address. Depending on what information is already present about a user, there may be additional steps.

If a user has active slices, there's another level altogether. Those slices were reserved with a certificate that embeds their email address, so that old email address is recorded at the aggregates.

ma_member_attribute

Update ma_member_attribute to set the new email address. Something like:

update ma_member_attribute set value = '[email protected]'
  where member_id = 'C061E955-70DC-4B37-9E57-ADEA251186C6'
    and name = 'email_address';

ma_inside_key

The idea with the inside certificate is to make the MA renew it, which will cause the new email address to be written into the new inside certificate. To do that, change the expiration date to the current day. Something like:

update ma_inside_key set expiration = now() at time zone 'UTC'
  where member_id = 'C061E955-70DC-4B37-9E57-ADEA251186C6';

ma_outside_cert

If the user has an outside certificate it has to be revoked and removed from the table. See Revoke user certificate for instructions.