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

     1  set global enable_privilege_cache = off;
     2  create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456';
     3  alter user 'root' identified by '111';
     4  create user admin_1 identified by '123456';
     5  create user admin_2 identified by '123456';
     6  alter user 'admin_1' identified by '111111';
     7  alter user 'admin_2' identified by '111111';
     8  alter user 'root' identified by '111', 'admin_1' identified by '123456';
     9  internal error: can only alter one user at a time
    10  alter user 'admin_1' identified by '123456', admin_2 identified by '123456';
    11  internal error: can only alter one user at a time
    12  alter user 'admin_3' identified by '111111';
    13  internal error: Operation ALTER USER failed for 'admin_3'@'%', user does't exist
    14  alter user if exists 'admin_2' identified by '111111';
    15  alter user 'root' identified by '111' LOCK;
    16  internal error: not support password or lock operation
    17  alter user 'root' identified by '111' PASSWORD HISTORY DEFAULT;
    18  internal error: not support password or lock operation
    19  alter user 'root' identified by '111' comment 'alter user test';
    20  internal error: not support alter comment or attribute
    21  alter user 'root' identified by '111' attribute 'test';
    22  internal error: not support alter comment or attribute
    23  drop account acc_idx;
    24  alter user root identified by 'UI235_ace';
    25  select user_name,status from mo_catalog.mo_user where user_name="root";
    26  user_name    status
    27  root    unlock
    28  create user  efg identified by '111';
    29  alter user `efg` identified by 'eee中文';
    30  show databases;
    31  internal error: do not have privilege to execute the statement
    32  create user hjk identified by '123456';
    33  alter user hjk identified by 'abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss244kkkkkkkkkkkkkkkkkkkkkkkkkkkkkk';
    34  show databases;
    35  internal error: do not have privilege to execute the statement
    36  alter user hjk identified by '';
    37  internal error: password is empty string
    38  alter user hjk identified by uuu;
    39  SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 32 near " uuu;";
    40  alter user aaa identified by '111';
    41  internal error: Operation ALTER USER failed for 'aaa'@'%', user does't exist
    42  create user opp identified by '12345';
    43  create role if not exists role1;
    44  grant CONNECT,create user,drop user on account * to role1;
    45  grant role1 to opp;
    46  create user rst identified by '12345';
    47  alter user rst identified by 'Nm_092324';
    48  internal error: do not have privilege to execute the statement
    49  drop user rst;
    50  drop user if exists efg;
    51  drop user if exists hjk;
    52  drop user if exists opp;
    53  drop role if exists role1;
    54  alter user root identified by '111';
    55  set global enable_privilege_cache = on;