test/tools/UserStmt/exp.test009.ksh

   1 Connecting User root
   2 echo create table t1(f1 int,f2 char(10));
   3 Statement Executed
   4 echo insert into t1 values(1,'root1');
   5 Statement Executed: Rows Affected = 1
   6 echo select * from t1;
   7 ---------------------------------------------------------
   8         t1.f1   t1.f2
   9 ---------------------------------------------------------
  10         1       root1
  11
  12 echo create user lakshya password 'lakshya123';
  13 Statement Executed
  14 echo show users;
  15 =============UserNames===================
  16    root
  17    lakshya
  18 =========================================
  19 echo Disconnecting User root
  20 quit;
  21 Connecting User lakshya
  22 echo create table t2(f1 int,f2 char(10));
  23 Statement Executed
  24 echo insert into t1 values(2,'root2');
  25 Statement Executed: Rows Affected = 1
  26 echo insert into t2 values(10,'lakshya');
  27 Statement Executed: Rows Affected = 1
  28 echo select * from t1;
  29 ---------------------------------------------------------
  30         t1.f1   t1.f2
  31 ---------------------------------------------------------
  32         1       root1
  33         2       root2
  34
  35 echo select * from t2;
  36 ---------------------------------------------------------
  37         t2.f1   t2.f2
  38 ---------------------------------------------------------
  39         10      lakshya
  40
  41 echo Disconnecting user lakshya
  42 quit;
  43 Connecting User root
  44 echo drop user lakshya;
  45 Statement Executed
  46 Statement Executed
  47 Statement Executed
  48 Test Passed