Support auth plugin

[bohutang]

Summary

• [x] #3480
• [x] #3482

[flaneur2020]

/assignme

[flaneur2020]

jwt might be a promising authentication option, like: https://trino.io/docs/current/security/jwt.html

[youngsofun]

@BohuTANG

after discussing with @flaneur2020, I think we may change password_type back to auth_type. and use the same field to hold enum { JTW, Sha256Password, DoubleSha1Password, ...}, which directly corresponds to the "With" part in SQL.

otherwise, we need another field to hold enum {JWT, Password, }, which is a waste and has no benefit.

and it is a little more convenient to use one field/var to dispatch auth logic and to be passed a argument

[youngsofun]

better way for rust is to use enum？

enum { Password（type PasswordType，password vec） Ldap（config string） }

[bohutang]

Ok, enum looks make sense.

[youngsofun]

ok, I will do it

[flaneur2020]

@youngsofun can take this issue assigned to yourself by /assignme :)

[youngsofun]

/assignme

[youngsofun]

plan with 3 pr:

• [ ] refactor auth with enum (user table, create/alter users parser and tests)
• [ ] continue to refactor auth framework and support simple JWT and HTTP basic(use existing password)
• [ ] store password as hashed value as it should be
• [ ] create root user

[Xuanwo]

All work has been done. Let's close.