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

     1  set global enable_privilege_cache = off;
     2  drop account if exists drop_account_01;
     3  drop account if exists drop_account_02;
     4  drop account if exists drop_account_03;
     5  drop account if exists drop_account_04;
     6  drop account if exists drop_account_05;
     7  drop database if exists drop_acc_db_1;
     8  create account drop_account_01 ADMIN_NAME 'root' IDENTIFIED BY '1234567890';
     9  select account_name from mo_catalog.mo_account where account_name='drop_account_01';
    10  account_name
    11  drop_account_01
    12  drop account drop_account_01;
    13  drop account drop_account_02;
    14  internal error: there is no account drop_account_02
    15  select account_name from mo_catalog.mo_account where account_name='drop_account_01';
    16  account_name
    17  create account if not exists drop_account_03 ADMIN_NAME 'root' IDENTIFIED BY '1234567890';
    18  drop account drop_account_03;
    19  drop account if exists drop_account_03;
    20  select account_name from mo_catalog.mo_account where account_name='drop_account_03';
    21  account_name
    22  create account drop_account_04 ADMIN_NAME 'root' IDENTIFIED BY '1234567890';
    23  drop account `drop_account_04`;
    24  create account if not exists drop_account_01 ADMIN_NAME 'root' IDENTIFIED BY '1234567890';
    25  PREPARE s1 FROM "drop account ?";
    26  set @a_var = 'drop_account_01';
    27  EXECUTE s1 USING @a_var;
    28  DEALLOCATE PREPARE s1;
    29  select account_name from mo_catalog.mo_account where account_name='drop_account_01';
    30  account_name
    31  drop account sys;
    32  internal error: can not delete the account sys
    33  drop accout abc;
    34  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;";
    35  drop account if not exists abc;
    36  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;";
    37  drop account exists abc;
    38  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;";
    39  drop account '';
    40  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 " '';";
    41  create account drop_account_05 ADMIN_NAME 'admin' IDENTIFIED BY '12345';
    42  create role drop_acc_role_1;
    43  create database drop_acc_db_1;
    44  create table drop_acc_db_1.drop_acc_tb_1(a int);
    45  insert into drop_acc_db_1.drop_acc_tb_1 values (20);
    46  create user drop_acc_user_1 identified by '1111' default role drop_acc_role_1;
    47  grant select ,insert ,update on table drop_acc_db_1.* to drop_acc_role_1 with grant option;
    48  drop account if exists drop_account_01;
    49  drop account if exists drop_account_02;
    50  drop account if exists drop_account_03;
    51  drop account if exists drop_account_04;
    52  drop account if exists drop_account_05;
    53  drop database if exists drop_acc_db_1;
    54  create account drop_account_test admin_name = 'root' identified by '111';
    55  CREATE DATABASE IF NOT EXISTS `sctc-ls`;
    56  CREATE DATABASE `emis_etao_006`;
    57  CREATE DATABASE `iot_etao_006`;
    58  CREATE DATABASE `xxl_job`;
    59  CREATE DATABASE `ucl360_bi`;
    60  CREATE DATABASE `ucl360_v3_20220823_unre_003`;
    61  CREATE DATABASE `ucl360_v210`;
    62  create database `111`;
    63  create database if not exists ucl360_v3_20220823;
    64  DROP ACCOUNT IF EXISTS drop_account_test;
    65  create account `ce46ba96_6c2f_4344_9b80_a1e9f03c600b` admin_name = 'root' identified by '111';
    66  CREATE DATABASE IF NOT EXISTS `sctc-ls`;
    67  CREATE DATABASE `emis_etao_006`;
    68  CREATE DATABASE `iot_etao_006`;
    69  CREATE DATABASE `xxl_job`;
    70  CREATE DATABASE `ucl360_bi`;
    71  CREATE DATABASE `ucl360_v3_20220823_unre_003`;
    72  CREATE DATABASE `ucl360_v210`;
    73  create database `111`;
    74  create database if not exists ucl360_v3_20220823;
    75  DROP ACCOUNT IF EXISTS `ce46ba96_6c2f_4344_9b80_a1e9f03c600b`;
    76  set global enable_privilege_cache = on;