test/tools/UserStmt/exp.test008.ksh

   1 Connecting User root
   2 echo create user nihar password 'nihar123';
   3 Statement Executed
   4 echo create user lakshya password 'lakshya123';
   5 Statement Executed
   6 Connecting User nihar
   7 echo show users;
   8 =============UserNames===================
   9    root
  10    nihar
  11    lakshya
  12 =========================================
  13 echo alter user lakshya set password 'lakshya321';
  14 Statement prepare failed with error -3
  15 echo Disconnecting User nihar
  16 quit;
  17 Connecting User root
  18 echo drop user nihar;
  19 Statement Executed
  20 echo drop user lakshya;
  21 Statement Executed
  22 echo show users;
  23 =============UserNames===================
  24    root
  25 =========================================
  26 Test Passed