user_create.sim

system sh/stop_dnodes.sh

system sh/ip.sh -i 1 -s up
system sh/deploy.sh -n dnode1 -m 192.168.0.1 -i 192.168.0.1
system sh/cfg.sh -n dnode1 -c clog -v 0
system sh/exec.sh -n dnode1 -s start
sql connect

print =============== step1
sql show users
if $rows != 3 then 
  return -1
endi

sql create user read PASS 'pass123'
sql create user read PASS 'pass123' -x step1
	return -1
step1:

sql show users
if $rows != 4 then 
  return -1
endi

sql alter user read PASS 'taosdata'

print =============== step2
sql close
sql connect read
sleep 2000

sql alter user read PASS 'taosdata'

print =============== step3
sql drop user read -x step31
  return -1
step31:
sql drop user sys -x step32
  return -1
step32:
sql drop user stream -x step33
  return -1
step33:

print =============== step4
sql close
sql connect
sleep 2000

sql alter user read privilege read
sql show users
if $data1_read != read then 
  return -1
endi

sql_error alter user read privilege super
sql show users
if $data1_read != read then
  return -1
endi

sql alter user read privilege write
sql show users
if $data1_read != write then 
  return -1
endi

sql alter user read privilege 1 -x step43
  return -1
step43:

sql drop user sys -x step41
  return -1
step41:

sql drop user stream -x step42
  return -1
step42:

sql drop user read