test/tools/UserStmt/exp.test003.ksh

   1 Connecting User root
   2 echo create user lakshya password 'lakshya123';
   3 Statement Executed
   4 echo create user lakshyasolution password 'lakshya123';
   5 Statement Executed
   6 echo show users;
   7 =============UserNames===================
   8    root
   9    lakshya
  10    lakshyasolution
  11 =========================================
  12 echo Disconnecting root user
  13 quit;
  14 Connecting User lakshya
  15 echo create user lakshyatraining password 'lakshya123';
  16 Statement prepare failed with error -3
  17 echo drop user lakshyasolution;
  18 Statement prepare failed with error -3
  19 echo Disconnecting user lakshya
  20 quit;
  21 Connecting User root
  22 echo show users;
  23 =============UserNames===================
  24    root
  25    lakshya
  26    lakshyasolution
  27 =========================================
  28 echo drop user lakshyasolution;
  29 Statement Executed
  30 echo  user lakshya;
  31 Statement Executed
  32 echo show users;
  33 =============UserNames===================
  34    root
  35 =========================================
  36 Test Passed