[Building Sakai] Puzzle: how to update SAKAI_USER_ID_MAP when LDAP username changes
    Joshua Swink 
    joshua.swink at gmail.com
       
    Fri Oct 15 10:11:38 PDT 2010
    
    
  
Oops, there were a couple of typos ('eid' where it should have said
'userid'). Correction below.
> 2b) If two results were returned, do a swap.
>
> delete from SAKAI_USER_ID_MAP where EID='<new-eid>';
> update SAKAI_USER_ID_MAP set EID='<new-eid>' where USER_ID='<old-userid>';
> insert into SAKAI_USER_ID_MAP (USER_ID, EID) values('<new-userid>', '<old-eid>');
Josh
    
    
More information about the sakai-dev
mailing list