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

     1  set global enable_privilege_cache = off;
     2  drop account if exists acc1;
     3  drop account if exists accx;
     4  --no error, no account nosys
     5  alter account if exists nosys admin_name 'root' identified by '1234';
     6  
     7  --error
     8  alter account nosys admin_name 'root' identified by '1234';
     9  
    10  --new account acc1
    11  create account acc1 admin_name "root1" identified by "111";
    12  
    13  --error, wrong admin_name "rootx" for acc1
    14  alter account acc1 admin_name "rootx" identified by "111";
    15  
    16  --error, wrong admin_name "rootx" for acc1
    17  alter account if exists acc1 admin_name "rootx" identified by "111";
    18  
    19  --no error
    20  alter account acc1 admin_name "root1" identified by "1234";
    21  
    22  --no error
    23  alter account if exists acc1 admin_name "root1" identified by "1234";
    24  
    25  --error, do not support IDENTIFIED BY RANDOM PASSWORD
    26  alter account if exists acc1 admin_name "root1" IDENTIFIED BY RANDOM PASSWORD;
    27  
    28  --error, do not support IDENTIFIED WITH 'abc'
    29  alter account if exists acc1 admin_name "root1" IDENTIFIED WITH 'abc';
    30  
    31  --error, at most one option at a time
    32  alter account if exists acc1 admin_name "root1" identified by "1234" suspend;
    33  
    34  --error, at most one option at a time
    35  alter account if exists acc1 suspend comment "acc1";
    36  
    37  --error, at most one option at a time
    38  alter account if exists acc1 admin_name "root1" identified by "1234" comment "acc1";
    39  
    40  --error, at least one option at a time
    41  alter account if exists acc1;
    42  
    43  --no error
    44  alter account acc1 comment "new accout";
    45  
    46  --no error, no account accx
    47  alter account if exists accx comment "new accout";
    48  
    49  --new account accx
    50  create account accx admin_name "root1" identified by "111";
    51  
    52  --no error
    53  alter account accx comment "new accout";
    54  
    55  --no error
    56  alter account accx suspend;
    57  
    58  --no error
    59  alter account accx open;
    60  
    61  drop account if exists acc1;
    62  drop account if exists accx;
    63  set global enable_privilege_cache = on;