test/tools/UserStmt/test008.ksh

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