2 #Test Case : Changing Password of a user through same user 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 # connect the user nihar as
8 # # csql -u nihar -p nihar123
9 # Change the password of user nihar as:
10 # CSQL> alter user nihar set password 'papu123'.
11 # It should be passed.
12 # Connect User nihar with new password. Connection should be established.
14 QUITFILE
=${PWD}/tools
/UserStmt
/csql.conf
18 REL_PATH
=`pwd`/tools
/UserStmt
23 rm -f ${REL_PATH}/usr.sql ${REL_PATH}angepassword.sql ${REL_PATH}/usrroot.sql
27 echo "echo create user nihar password 'nihar123';" >${REL_PATH}/usr.sql
28 echo "create user nihar password 'nihar123';" >>${REL_PATH}/usr.sql
29 echo "quit;" >>${REL_PATH}/usr.sql
31 echo "echo show users;" >${REL_PATH}/changepassword.sql
32 echo "show users;" >>${REL_PATH}/changepassword.sql
33 echo "echo alter user nihar set password 'papu123';" >>${REL_PATH}/changepassword.sql
34 echo "alter user nihar set password 'papu123';" >>${REL_PATH}/changepassword.sql
35 echo "echo Disconnecting User nihar" >>${REL_PATH}/changepassword.sql
36 echo "quit;" >>${REL_PATH}/changepassword.sql
38 echo "echo drop user nihar;" >${REL_PATH}/usrroot.sql
39 echo "drop user nihar;" >>${REL_PATH}/usrroot.sql
40 echo "echo show users;">>${REL_PATH}/usrroot.sql
41 echo "show users;">>${REL_PATH}/usrroot.sql
42 echo "quit;" >>${REL_PATH}/usrroot.sql
44 echo "Connecting User root"
45 if [ "$VALGRIND" = "true" ]
47 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usr.sql
49 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usr.sql
56 echo "Connecting User nihar"
57 if [ "$VALGRIND" = "true" ]
59 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u nihar
-p nihar123
-s ${REL_PATH}/changepassword.sql
61 $CSQL_INSTALL_ROOT/bin
/csql
-u nihar
-p nihar123
-s ${REL_PATH}/changepassword.sql
68 echo "Connecting User root"
69 if [ "$VALGRIND" = "true" ]
71 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usrroot.sql
73 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usrroot.sql