test/tools/UserStmt/test003.ksh

   1 #!/bin/ksh
   2 #Test Case : Creating and Dropping users through the users other than root user
   3 #Test Case : Creating and Dropping users through the users other than root u
   4 # Connect csql as root as:
   5 # # csql -u root -p manager
   6 # create a user say "lakshya" as:
   7 # CSQL> create user lakshya password 'lakshya123';
   8 # create another user say "lakshyasolutions" as:
   9 # CSQL> create user lakshyasolutions password 'lakshya123';
  10 # CSQL> quit;
  11 # connect to "lakshya" user as
  12 # # csql -u lakshya -p lakshya123
  13 # Try to create another user say "lakshyatraining"
  14 # CSQL> create user lakshyatraining password 'bbsr';
  15 # It should be failed saying Other than root user no one can create user.
  16 # Try to drop the user lakshyasolutions as:
  17 # CSQL> drop user lakshyasolutions;
  18 # It should be failed
  19 # Try to drop "lakshya"
  20 # It should be failed because you can not drop self user.
  21
  22 QUITFILE=${PWD}/tools/UserStmt/csql.conf
  23 REL_PATH=.
  24 if [ -s "$QUITFILE" ]
  25 then
  26     REL_PATH=`pwd`/tools/UserStmt
  27 fi
  28
  29 exitStatus()
  30 {
  31     rm -f ${REL_PATH}/usr.sql ${REL_PATH}/usrlakshya.sql ${REL_PATH}/usrroot.sql
  32     echo "Test $1"
  33     exit $2;
  34 }
  35
  36 echo "echo create user lakshya password 'lakshya123';" >${REL_PATH}/usr.sql
  37 echo "create user lakshya password 'lakshya123';" >>${REL_PATH}/usr.sql
  38 echo "echo create user lakshyasolution password 'lakshya123';" >>${REL_PATH}/usr.sql
  39 echo "create user lakshyasolution password 'lakshya123';" >>${REL_PATH}/usr.sql
  40 echo "echo show users;" >>${REL_PATH}/usr.sql
  41 echo "show users;" >>${REL_PATH}/usr.sql
  42 echo "echo Disconnecting root user" >>${REL_PATH}/usr.sql
  43 echo "quit;" >>${REL_PATH}/usr.sql
  44
  45 echo "echo create user lakshyatraining password 'lakshya123';" >${REL_PATH}/usrlakshya.sql
  46 echo "create user lakshyatraining password 'lakshya123';" >>${REL_PATH}/usrlakshya.sql
  47 echo "echo drop user lakshyasolution;" >>${REL_PATH}/usrlakshya.sql
  48 echo "drop user lakshyasolution;" >>${REL_PATH}/usrlakshya.sql
  49 echo "echo Disconnecting user lakshya" >>${REL_PATH}/usrlakshya.sql
  50 echo "quit;" >>${REL_PATH}/usrlakshya.sql
  51
  52 echo "echo show users;" >${REL_PATH}/usrroot.sql
  53 echo "show users;" >>${REL_PATH}/usrroot.sql
  54 echo "echo drop user lakshyasolution;" >>${REL_PATH}/usrroot.sql
  55 echo "drop user lakshyasolution;" >>${REL_PATH}/usrroot.sql
  56 echo "echo  user lakshya;" >>${REL_PATH}/usrroot.sql
  57 echo "drop user lakshya;" >>${REL_PATH}/usrroot.sql
  58 echo "echo show users;" >>${REL_PATH}/usrroot.sql
  59 echo "show users;" >>${REL_PATH}/usrroot.sql
  60 echo "quit;" >>${REL_PATH}/usrroot.sql
  61
  62 echo "Connecting User root"
  63 if [ "$VALGRIND" = "true" ]
  64 then
  65    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  66 else
  67    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  68    if [ $? -ne 0 ]
  69    then
  70       exitStatus Failed 1;
  71    fi
  72 fi
  73
  74 echo "Connecting User lakshya"
  75 if [ "$VALGRIND" = "true" ]
  76 then
  77    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u lakshya -p lakshya123 -s ${REL_PATH}/usrlakshya.sql
  78 else
  79    $CSQL_INSTALL_ROOT/bin/csql -u lakshya -p lakshya123 -s ${REL_PATH}/usrlakshya.sql
  80    if [ $? -ne 0 ]
  81    then
  82       exitStatus Failed 2;
  83    fi
  84 fi
  85
  86 echo "Connecting User root"
  87 if [ "$VALGRIND" = "true" ]
  88 then
  89    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usrroot.sql
  90 else
  91    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usrroot.sql
  92    if [ $? -ne 0 ]
  93    then
  94       exitStatus Failed 3;
  95    fi
  96 fi
  97
  98 exitStatus Passed 0;