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'.
15 QUITFILE
=${PWD}/tools
/UserStmt
/csql.conf
19 REL_PATH
=`pwd`/tools
/UserStmt
24 rm -f ${REL_PATH}/usr.sql ${REL_PATH}/changepassword.sql ${REL_PATH}/usrroot.sql
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
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
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
50 echo "Connecting User root"
51 if [ "$VALGRIND" = "true" ]
53 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usr.sql
55 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usr.sql
62 echo "Connecting User nihar"
63 if [ "$VALGRIND" = "true" ]
65 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u nihar
-p nihar123
-s ${REL_PATH}/changepassword.sql
67 $CSQL_INSTALL_ROOT/bin
/csql
-u nihar
-p nihar123
-s ${REL_PATH}/changepassword.sql
74 echo "Connecting User root"
75 if [ "$VALGRIND" = "true" ]
77 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usrroot.sql
79 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usrroot.sql