[GitHub] [doris] stalary commented on a diff in pull request #13051: [feature](auth) support user password policy and alter user stmt

[GitBox]

stalary commented on code in PR #13051:
URL: https://github.com/apache/doris/pull/13051#discussion_r990881647


##########
docs/zh-CN/docs/sql-manual/sql-reference/Account-Management-Statements/CREATE-USER.md:
##########
@@ -87,6 +112,18 @@ host 部分也可指定为 domain，语法为：'user_name'@['domain']，即使
     CREATE USER 'jack'@'%' IDENTIFIED BY '12345' DEFAULT ROLE 'my_role';
     ```
 
+7. 创建一个用户，设定密码10天后过期，并且设置如果3次错误登录则账户会被锁定一天。
+
+    ```sql
+    CREATe USER 'jack' IDENTIFIED BY '12345' PASSWORD_EXPIRE INTERVAL 10 DAYS 
FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 1;

Review Comment:
   ```suggestion
       CREATE USER 'jack' IDENTIFIED BY '12345' PASSWORD_EXPIRE INTERVAL 10 DAY 
FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 1 DAY;
   ```



##########
docs/zh-CN/docs/sql-manual/sql-reference/Account-Management-Statements/CREATE-USER.md:
##########
@@ -87,6 +112,18 @@ host 部分也可指定为 domain，语法为：'user_name'@['domain']，即使
     CREATE USER 'jack'@'%' IDENTIFIED BY '12345' DEFAULT ROLE 'my_role';
     ```
 
+7. 创建一个用户，设定密码10天后过期，并且设置如果3次错误登录则账户会被锁定一天。
+
+    ```sql
+    CREATe USER 'jack' IDENTIFIED BY '12345' PASSWORD_EXPIRE INTERVAL 10 DAYS 
FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 1;
+    ```
+
+8. 创建一个用户，并限制不可重置密码为最近8次是用过的密码。
+
+    ```sql
+    CREATe USER 'jack' IDENTIFIED BY '12345' PASSWORD_HISTORY 8;

Review Comment:
   ```suggestion
       CREATE USER 'jack' IDENTIFIED BY '12345' PASSWORD_HISTORY 8;
   ```



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org