github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/zz_accesscontrol/drop_account.result (about)

     1  drop account if exists drop_account_01;
     2  drop account if exists drop_account_02;
     3  drop account if exists drop_account_03;
     4  drop account if exists drop_account_04;
     5  drop account if exists drop_account_05;
     6  drop database if exists drop_acc_db_1;
     7  create account drop_account_01 ADMIN_NAME 'root' IDENTIFIED BY '1234567890';
     8  select account_name from mo_catalog.mo_account where account_name='drop_account_01';
     9  account_name
    10  drop_account_01
    11  drop account drop_account_01;
    12  drop account drop_account_02;
    13  internal error: there is no account drop_account_02
    14  select account_name from mo_catalog.mo_account where account_name='drop_account_01';
    15  account_name
    16  create account if not exists drop_account_03 ADMIN_NAME 'root' IDENTIFIED BY '1234567890';
    17  drop account drop_account_03;
    18  drop account if exists drop_account_03;
    19  select account_name from mo_catalog.mo_account where account_name='drop_account_03';
    20  account_name
    21  create account drop_account_04 ADMIN_NAME 'root' IDENTIFIED BY '1234567890';
    22  drop account `drop_account_04`;
    23  drop account sys;
    24  internal error: can not delete the account sys
    25  drop accout abc;
    26  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 11 near " accout abc;";
    27  drop account if not exists abc;
    28  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 19 near " not exists abc;";
    29  drop account exists abc;
    30  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 19 near " exists abc;";
    31  drop account '';
    32  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 15 near " '';";
    33  create account drop_account_05 ADMIN_NAME 'admin' IDENTIFIED BY '12345';
    34  create role drop_acc_role_1;
    35  create database drop_acc_db_1;
    36  create table drop_acc_db_1.drop_acc_tb_1(a int);
    37  insert into drop_acc_db_1.drop_acc_tb_1 values (20);
    38  create user drop_acc_user_1 identified by '1111' default role drop_acc_role_1;
    39  grant select ,insert ,update on table drop_acc_db_1.* to drop_acc_role_1 with grant option;
    40  drop account if exists drop_account_01;
    41  drop account if exists drop_account_02;
    42  drop account if exists drop_account_03;
    43  drop account if exists drop_account_04;
    44  drop account if exists drop_account_05;
    45  drop database if exists drop_acc_db_1;