test/tools/UserStmt/test002.ksh

   1 #!/bin/ksh
   2 #Test Case : Showing all users and Dropping users except root user through root user should be allowed
   3 # Connect root user as:
   4 # # csql -u root -p manager
   5 # create 3 user other than root
   6 # Show all users using "show users" statement. It should show all users including root user.
   7 # Drop all the users. U should be able to drop all the users except root 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 create user lakshya password 'lakshya123';" >${REL_PATH}/usr.sql
  24 echo "create user lakshya password 'lakshya123';" >>${REL_PATH}/usr.sql
  25 echo "echo create user lakshyatraining password 'lakshya123';" >>${REL_PATH}/usr.sql
  26 echo "create user lakshyatraining password 'lakshya123';" >>${REL_PATH}/usr.sql
  27 echo "echo create user lakshyasolution password 'lakshya123';" >>${REL_PATH}/usr.sql
  28 echo "create user lakshyasolution password 'lakshya123';" >>${REL_PATH}/usr.sql
  29 echo "echo show users;" >>${REL_PATH}/usr.sql
  30 echo "show users;" >>${REL_PATH}/usr.sql
  31 echo "echo drop user lakshya;" >>${REL_PATH}/usr.sql
  32 echo "drop user lakshya;" >>${REL_PATH}/usr.sql
  33 echo "echo drop user lakshyatraining;" >>${REL_PATH}/usr.sql
  34 echo "drop user lakshyatraining;" >>${REL_PATH}/usr.sql
  35 echo "echo drop user lakshyasolution;" >>${REL_PATH}/usr.sql
  36 echo "drop user lakshyasolution;" >>${REL_PATH}/usr.sql
  37 echo "quit;" >>${REL_PATH}/usr.sql
  38
  39 if [ "$VALGRIND" = "true" ]
  40 then
  41    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  42 else
  43    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  44    if [ $? -ne 0 ]
  45    then
  46       exitStatus Failed 1;
  47    fi
  48 fi
  49
  50 exitStatus Passed 0;