#!/bin/ksh

if [ $# -ne 4 ]; then
  echo "Usage: $0 <DBNAME> <DBAPWD> <vallep-PWD> <test1-PWD> "
  exit 1
fi

/sapdb/programs/bin/sqlcli -d $1 -u dba,$2 << EOF
CREATE USER vallep PASSWORD $3 RESOURCE NOT EXCLUSIVE
CREATE USER test1 PASSWORD $4 RESOURCE NOT EXCLUSIVE
exit
EOF

cat << EOF

Users created in DB $1:

User  Password
----  --------
vallep   $3
test1   $4
EOF