chg_pword()
{

USR=$1
PWRD=$2

##############################################
# This should replace the functions:
#     chg_pword_all_SCHEMA_T11()
#
# Change SCHEMA_C21_* schema/users passwords
# After schema creation we will run this
# function could accept parameters for schema
##############################################

echo
echo "Change passwords for user/schema ${USR} "
echo

sqlplus -s "/ as sysdba" <<EOF
set lines 150
set pages 150

alter user ${USR} identified by ${PWRD};

alter user ${USR} account unlock;

EOF

}

Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram