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

     1  set global enable_privilege_cache = off;
     2  drop account if exists acc1;
     3  drop account if exists accx;
     4  alter account if exists nosys admin_name 'root' identified by '1234';
     5  alter account nosys admin_name 'root' identified by '1234';
     6  internal error: there is no account nosys
     7  create account acc1 admin_name "root1" identified by "111";
     8  alter account acc1 admin_name "rootx" identified by "111";
     9  internal error: there is no user rootx
    10  alter account if exists acc1 admin_name "rootx" identified by "111";
    11  internal error: there is no user rootx
    12  alter account acc1 admin_name "root1" identified by "1234";
    13  alter account if exists acc1 admin_name "root1" identified by "1234";
    14  alter account if exists acc1 admin_name "root1" IDENTIFIED BY RANDOM PASSWORD;
    15  internal error: only support identified by password
    16  alter account if exists acc1 admin_name "root1" IDENTIFIED WITH 'abc';
    17  internal error: only support identified by password
    18  alter account if exists acc1 admin_name "root1" identified by "1234" suspend;
    19  internal error: at most one option at a time
    20  alter account if exists acc1 suspend comment "acc1";
    21  internal error: at most one option at a time
    22  alter account if exists acc1 admin_name "root1" identified by "1234" comment "acc1";
    23  internal error: at most one option at a time
    24  alter account if exists acc1;
    25  internal error: at least one option at a time
    26  alter account acc1 comment "new accout";
    27  alter account if exists accx comment "new accout";
    28  create account accx admin_name "root1" identified by "111";
    29  alter account accx comment "new accout";
    30  alter account accx suspend;
    31  alter account accx open;
    32  drop account if exists acc1;
    33  drop account if exists accx;
    34  set global enable_privilege_cache = on;