Tuesday, November 4, 2008

Inline alter user password

chgPassword=`/opt/oracle/9.2.0/bin/sqlplus
-L ${user_id}/${OLD_PWD}@$db_name<<XX
alter user $user_id identified by "$NEW_PWD";
exit;
XX`
RESULT=`echo ${chgPassword}`
if [ -z "$RESULT" ] ; then
      ActionStatus "FAILED"
else
      echo ${NEW_PWD} > ${pwdPath}${ds_name}.pwd
      ActionStatus "END"
fi

No comments: