test/tools/UserStmt/exp.test006.ksh

   1 Connecting User root
   2 echo create user nihar password 'nihar123';
   3 Statement Executed
   4 echo alter user nihar set password 'papu123';
   5 Statement Executed: Rows Affected = 0
   6 Connecting User nihar using new Password
   7 echo show users;
   8 =============UserNames===================
   9    root
  10    nihar
  11 =========================================
  12 echo Disconnecting User nihar
  13 quit;
  14 Connecting User root
  15 echo drop user nihar;
  16 Statement Executed
  17 echo show users;
  18 =============UserNames===================
  19    root
  20 =========================================
  21 Test Passed