user_create.sim

sql connect
sleep 3000

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 alter user read privilege super
sql show users
if $data1_read != super 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