test/tools/UserStmt/test006.ksh

   1 #!/bin/ksh
   2 #Test Case : Changing Password of an existing user through root user and connecting to that user with new password 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 # Change the password of user nihar as:
   8 # CSQL> alter user nihar set password 'papu123'.
   9 # It should be passed.
  10 # Connect User nihar with new password. Connection should be established.
  11
  12 QUITFILE=${PWD}/tools/UserStmt/csql.conf
  13 REL_PATH=.
  14 if [ -s "$QUITFILE" ]
  15 then
  16     REL_PATH=`pwd`/tools/UserStmt
  17 fi
  18
  19 exitStatus()
  20 {
  21     rm -f ${REL_PATH}/usr.sql ${REL_PATH}/qut.sql ${REL_PATH}/usrroot.sql
  22     echo "Test $1"
  23     exit $2;
  24 }
  25
  26 echo "echo create user nihar password 'nihar123';" >${REL_PATH}/usr.sql
  27 echo "create user nihar password 'nihar123';" >>${REL_PATH}/usr.sql
  28 echo "echo alter user nihar set password 'papu123';" >>${REL_PATH}/usr.sql
  29 echo "alter user nihar set password 'papu123';" >>${REL_PATH}/usr.sql
  30 echo "quit;" >>${REL_PATH}/usr.sql
  31
  32 echo "echo show users;" >${REL_PATH}/qut.sql
  33 echo "show users;" >>${REL_PATH}/qut.sql
  34 echo "echo Disconnecting User nihar" >>${REL_PATH}/qut.sql
  35 echo "quit;" >>${REL_PATH}/qut.sql
  36
  37 echo "echo drop user nihar;" >${REL_PATH}/usrroot.sql
  38 echo "drop user nihar;" >>${REL_PATH}/usrroot.sql
  39 echo "echo show users;">>${REL_PATH}/usrroot.sql
  40 echo "show users;">>${REL_PATH}/usrroot.sql
  41 echo "quit;" >>${REL_PATH}/usrroot.sql
  42
  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 using new Password"
  57 if [ "$VALGRIND" = "true" ]
  58 then
  59    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u nihar -p papu123 -s ${REL_PATH}/qut.sql
  60 else
  61    $CSQL_INSTALL_ROOT/bin/csql -u nihar -p papu123 -s ${REL_PATH}/qut.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;