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

     1  --prepared
     2  drop account if exists test;
     3  create account test ADMIN_NAME 'admin' IDENTIFIED BY '111';
     4  PREPARE alter_ac_1 FROM alter account ? admin_name= ? IDENTIFIED BY ?;
     5  set @a_var = 'test';
     6  set @b_var = 'admin';
     7  set @c_var = '222';
     8  EXECUTE alter_ac_1 USING @a_var, @b_var, @c_var;
     9  DEALLOCATE PREPARE alter_ac_1;
    10  -- @session:id=2&user=test:admin&password=222
    11  select 1;
    12  -- @session
    13  PREPARE alter_ac_2 FROM "alter account ? admin_name 'admin' IDENTIFIED BY ?";
    14  set @a_var = 'test';
    15  set @c_var = '333';
    16  EXECUTE alter_ac_2 USING @a_var, @c_var;
    17  DEALLOCATE PREPARE alter_ac_2;
    18  -- @session:id=3&user=test:admin&password=333
    19  select 1;
    20  -- @session
    21  PREPARE alter_ac_3 FROM "alter account test admin_name 'admin' IDENTIFIED BY ?";
    22  set @c_var = '444';
    23  EXECUTE alter_ac_3 USING @c_var;
    24  DEALLOCATE PREPARE alter_ac_3;
    25  -- @session:id=4&user=test:admin&password=444
    26  select 1;
    27  -- @session
    28  drop account if exists test;