test/tools/UserStmt/test004.ksh

   1 #!/bin/ksh
   2 #Test Case : Dropping root user through the root user should be failed
   3 # Connect to root user as:
   4 # # csql -u root -p manager
   5 # Try to drop root user as:
   6 # CSQL> drop user root
   7 # It should be failed because you can not drop self user.
   8
   9 QUITFILE=${PWD}/tools/UserStmt/csql.conf
  10 REL_PATH=.
  11 if [ -s "$QUITFILE" ]
  12 then
  13     REL_PATH=`pwd`/tools/UserStmt
  14 fi
  15
  16 exitStatus()
  17 {
  18     rm -f ${REL_PATH}/usr.sql
  19     echo "Test $1"
  20     exit $2;
  21 }
  22
  23 echo "echo drop user root;" >${REL_PATH}/usr.sql
  24 echo "drop user root;" >>${REL_PATH}/usr.sql
  25 echo "quit;" >>${REL_PATH}/usr.sql
  26
  27 echo "Connecting User root"
  28 if [ "$VALGRIND" = "true" ]
  29 then
  30    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  31 else
  32    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  33    if [ $? -ne 0 ]
  34    then
  35       exitStatus Failed 1;
  36    fi
  37 fi
  38
  39 exitStatus Passed 0;