Change Email

How to change a portal user's email address

There are four 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';

identity_attribute

The identity_attribute table is slated for removal but as of this writing is still active. The email address is stored in this table as well, so a similar command has to be run:

update identity_attribute
  set value = '[email protected]'
  where name = 'mail'
    and value = '[email protected]';

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 = '2015-04-01 12:34:56'
  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.