update pdm.pdm_user
set userexpname='smithj'
where userexpname='johnsmith';

update pdm.pdm_user
set username='smithj'
where username='johnsmith';
commit;