try something like this

update TABLE_X A
set A.TX_PASS = (
SELECT B.TX_PASS
FROM TABLE_Y B
WHERE A.CD_USER = B.CD_USER
)