user_create.sim

system sh/stop_dnodes.sh


system sh/deploy.sh -n dnode1 -i 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
print $data1_read
if $data1_read != readable then 
  return -1
endi

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

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