github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/alter_user_password.sql (about)

     1  set global enable_privilege_cache = off;
     2  create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456';
     3  -- @session:id=1&user=acc_idx:root&password=123456
     4  alter user 'root' identified by '111';
     5  create user admin_1 identified by '123456';
     6  create user admin_2 identified by '123456';
     7  alter user 'admin_1' identified by '111111';
     8  alter user 'admin_2' identified by '111111';
     9  alter user 'root' identified by '111', 'admin_1' identified by '123456';
    10  alter user 'admin_1' identified by '123456', admin_2 identified by '123456';
    11  alter user 'admin_3' identified by '111111';
    12  alter user if exists 'admin_2' identified by '111111';
    13  alter user 'root' identified by '111' LOCK;
    14  alter user 'root' identified by '111' PASSWORD HISTORY DEFAULT;
    15  alter user 'root' identified by '111' comment 'alter user test';
    16  alter user 'root' identified by '111' attribute 'test';
    17  -- @session
    18  drop account acc_idx;
    19  alter user root identified by 'UI235_ace';
    20  -- @session:id=2&user=sys:root&password=UI235_ace
    21  select user_name,status from mo_catalog.mo_user where user_name="root";
    22  -- @session
    23  create user  efg identified by '111';
    24  alter user `efg` identified by 'eee中文';
    25  -- @session:id=3&user=sys:efg:public&password=eee中文
    26  show databases;
    27  -- @session
    28  create user hjk identified by '123456';
    29  alter user hjk identified by 'abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss244kkkkkkkkkkkkkkkkkkkkkkkkkkkkkk';
    30  -- @session:id=4&user=sys:hjk&password=abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss244kkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
    31  show databases;
    32  -- @session
    33  
    34  --anormal test
    35  alter user hjk identified by '';
    36  alter user hjk identified by uuu;
    37  alter user aaa identified by '111';
    38  
    39  --privs
    40  create user opp identified by '12345';
    41  create role if not exists role1;
    42  grant CONNECT,create user,drop user on account * to role1;
    43  grant role1 to opp;
    44  -- @session:id=5&user=sys:opp:role1&password=12345
    45  create user rst identified by '12345';
    46  alter user rst identified by 'Nm_092324';
    47  drop user rst;
    48  -- @session
    49  drop user if exists efg;
    50  drop user if exists hjk;
    51  drop user if exists opp;
    52  drop role if exists role1;
    53  alter user root identified by '111';
    54  set global enable_privilege_cache = on;