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

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