test/tools/UserStmt/test007.ksh

   1 #!/bin/ksh
   2 #Test Case : Changing Password of a user through same user should be passed
   3 # Connect to root user as:
   4 # # csql -u root -p manager
   5 # create a user say nihar as:
   6 # CSQL> create user nihar password 'nihar123'.
   7 # connect the user nihar as
   8 # # csql -u nihar -p nihar123
   9 # Change the password of user nihar as:
  10 # CSQL> alter user nihar set password 'papu123'.
  11 # It should be passed.
  12 # Connect User nihar with new password. Connection should be established.
  13
  14 QUITFILE=${PWD}/tools/UserStmt/csql.conf
  15 REL_PATH=.
  16 if [ -s "$QUITFILE" ]
  17 then
  18     REL_PATH=`pwd`/tools/UserStmt
  19 fi
  20
  21 exitStatus()
  22 {
  23     rm -f ${REL_PATH}/usr.sql ${REL_PATH}angepassword.sql ${REL_PATH}/usrroot.sql
  24     echo "Test $1"
  25     exit $2;
  26 }
  27 echo "echo create user nihar password 'nihar123';" >${REL_PATH}/usr.sql
  28 echo "create user nihar password 'nihar123';" >>${REL_PATH}/usr.sql
  29 echo "quit;" >>${REL_PATH}/usr.sql
  30
  31 echo "echo show users;" >${REL_PATH}/changepassword.sql
  32 echo "show users;" >>${REL_PATH}/changepassword.sql
  33 echo "echo alter user nihar set password 'papu123';" >>${REL_PATH}/changepassword.sql
  34 echo "alter user nihar set password 'papu123';" >>${REL_PATH}/changepassword.sql
  35 echo "echo Disconnecting User nihar" >>${REL_PATH}/changepassword.sql
  36 echo "quit;" >>${REL_PATH}/changepassword.sql
  37
  38 echo "echo drop user nihar;" >${REL_PATH}/usrroot.sql
  39 echo "drop user nihar;" >>${REL_PATH}/usrroot.sql
  40 echo "echo show users;">>${REL_PATH}/usrroot.sql
  41 echo "show users;">>${REL_PATH}/usrroot.sql
  42 echo "quit;" >>${REL_PATH}/usrroot.sql
  43
  44 echo "Connecting User root"
  45 if [ "$VALGRIND" = "true" ]
  46 then
  47    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  48 else
  49    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  50    if [ $? -ne 0 ]
  51    then
  52       exitStatus Failed 1;
  53    fi
  54 fi
  55
  56 echo "Connecting User nihar"
  57 if [ "$VALGRIND" = "true" ]
  58 then
  59    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u nihar -p nihar123 -s ${REL_PATH}/changepassword.sql
  60 else
  61    $CSQL_INSTALL_ROOT/bin/csql -u nihar -p nihar123 -s ${REL_PATH}/changepassword.sql
  62    if [ $? -ne 0 ]
  63    then
  64       exitStatus Failed 2;
  65    fi
  66 fi
  67
  68 echo "Connecting User root"
  69 if [ "$VALGRIND" = "true" ]
  70 then
  71    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usrroot.sql
  72 else
  73    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usrroot.sql
  74    if [ $? -ne 0 ]
  75    then
  76       exitStatus Failed 3;
  77    fi
  78 fi
  79
  80 exitStatus Passed 0;