github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/operate_catalog.result (about)

     1  set global enable_privilege_cache = off;
     2  drop database mo_catalog;
     3  internal error: do not have privilege to execute the statement
     4  drop database system;
     5  internal error: do not have privilege to execute the statement
     6  drop database system_metrics;
     7  internal error: do not have privilege to execute the statement
     8  drop database information_schema;
     9  internal error: do not have privilege to execute the statement
    10  use mo_catalog;
    11  drop table mo_database;
    12  internal error: do not have privilege to execute the statement
    13  drop table mo_tables;
    14  internal error: do not have privilege to execute the statement
    15  drop table mo_columns;
    16  internal error: do not have privilege to execute the statement
    17  drop table mo_user;
    18  internal error: do not have privilege to execute the statement
    19  drop table mo_account;
    20  internal error: do not have privilege to execute the statement
    21  drop table mo_role;
    22  internal error: do not have privilege to execute the statement
    23  drop table mo_user_grant;
    24  internal error: do not have privilege to execute the statement
    25  drop table mo_role_grant;
    26  internal error: do not have privilege to execute the statement
    27  drop table mo_role_privs;
    28  internal error: do not have privilege to execute the statement
    29  create table A(a int);
    30  internal error: do not have privilege to execute the statement
    31  drop table mo_catalog.mo_database;
    32  internal error: do not have privilege to execute the statement
    33  drop table mo_catalog.mo_tables;
    34  internal error: do not have privilege to execute the statement
    35  drop table mo_catalog.mo_columns;
    36  internal error: do not have privilege to execute the statement
    37  drop table mo_catalog.mo_user;
    38  internal error: do not have privilege to execute the statement
    39  drop table mo_catalog.mo_account;
    40  internal error: do not have privilege to execute the statement
    41  drop table mo_catalog.mo_role;
    42  internal error: do not have privilege to execute the statement
    43  drop table mo_catalog.mo_user_grant;
    44  internal error: do not have privilege to execute the statement
    45  drop table mo_catalog.mo_role_grant;
    46  internal error: do not have privilege to execute the statement
    47  drop table mo_catalog.mo_role_privs;
    48  internal error: do not have privilege to execute the statement
    49  create table mo_catalog.A(a int);
    50  internal error: do not have privilege to execute the statement
    51  update mo_role_grant set granted_id = 0;
    52  internal error: do not have privilege to execute the statement
    53  update mo_catalog.mo_role_grant set granted_id = 0;
    54  internal error: do not have privilege to execute the statement
    55  insert into mo_role_grant values (100,101,0,0,"2022-10-09 00:00:00",true);
    56  internal error: do not have privilege to execute the statement
    57  insert into mo_catalog.mo_role_grant values (100,101,0,0,"2022-10-09 00:00:00",true);
    58  internal error: do not have privilege to execute the statement
    59  delete from mo_role_grant;
    60  internal error: do not have privilege to execute the statement
    61  delete from mo_catalog.mo_role_grant;
    62  internal error: do not have privilege to execute the statement
    63  use system;
    64  drop table statement_info;
    65  internal error: do not have privilege to execute the statement
    66  drop table span_info;
    67  internal error: do not have privilege to execute the statement
    68  drop table log_info;
    69  internal error: do not have privilege to execute the statement
    70  drop table error_info;
    71  internal error: do not have privilege to execute the statement
    72  create table A(a int);
    73  internal error: do not have privilege to execute the statement
    74  drop table system.statement_info;
    75  internal error: do not have privilege to execute the statement
    76  drop table system.span_info;
    77  internal error: do not have privilege to execute the statement
    78  drop table system.log_info;
    79  internal error: do not have privilege to execute the statement
    80  drop table system.error_info;
    81  internal error: do not have privilege to execute the statement
    82  create table system.A(a int);
    83  internal error: do not have privilege to execute the statement
    84  update statement_info set statement_id = "1111";
    85  internal error: do not have privilege to execute the statement
    86  update error_info set err_code = "1111";
    87  invalid input: cannot insert/update/delete from view
    88  update system.error_info set err_code = "1111";
    89  invalid input: cannot insert/update/delete from view
    90  insert into error_info values ("2022-10-09 00:00:00", "1", "1", "1", "1", "1");
    91  invalid input: cannot insert/update/delete from view
    92  insert into system.error_info values ("2022-10-09 00:00:00", "1", "1", "1", "1", "1");
    93  invalid input: cannot insert/update/delete from view
    94  delete from error_info;
    95  invalid input: cannot insert/update/delete from view
    96  delete from system.error_info;
    97  invalid input: cannot insert/update/delete from view
    98  delete from system.statement_info;
    99  internal error: do not have privilege to execute the statement
   100  use system_metrics;
   101  drop table sql_statement_total;
   102  internal error: do not have privilege to execute the statement
   103  drop table sql_transaction_errors;
   104  internal error: do not have privilege to execute the statement
   105  drop table sql_statement_errors;
   106  internal error: do not have privilege to execute the statement
   107  drop table server_connections;
   108  internal error: do not have privilege to execute the statement
   109  drop table process_cpu_percent;
   110  internal error: do not have privilege to execute the statement
   111  drop table process_resident_memory_bytes;
   112  internal error: do not have privilege to execute the statement
   113  drop table process_open_fds;
   114  internal error: do not have privilege to execute the statement
   115  drop table process_max_fds;
   116  internal error: do not have privilege to execute the statement
   117  drop table sys_cpu_seconds_total;
   118  internal error: do not have privilege to execute the statement
   119  drop table sys_cpu_combined_percent;
   120  internal error: do not have privilege to execute the statement
   121  drop table sys_memory_used;
   122  internal error: do not have privilege to execute the statement
   123  drop table sys_memory_available;
   124  internal error: do not have privilege to execute the statement
   125  drop table sys_disk_read_bytes;
   126  internal error: do not have privilege to execute the statement
   127  drop table sys_disk_write_bytes;
   128  internal error: do not have privilege to execute the statement
   129  drop table sys_net_recv_bytes;
   130  internal error: do not have privilege to execute the statement
   131  drop table sys_net_sent_bytes;
   132  internal error: do not have privilege to execute the statement
   133  create table A(a int);
   134  internal error: do not have privilege to execute the statement
   135  drop table system_metrics.sql_statement_total;
   136  internal error: do not have privilege to execute the statement
   137  drop table system_metrics.sql_transaction_errors;
   138  internal error: do not have privilege to execute the statement
   139  drop table system_metrics.sql_statement_errors;
   140  internal error: do not have privilege to execute the statement
   141  drop table system_metrics.server_connections;
   142  internal error: do not have privilege to execute the statement
   143  drop table system_metrics.process_cpu_percent;
   144  internal error: do not have privilege to execute the statement
   145  drop table system_metrics.process_resident_memory_bytes;
   146  internal error: do not have privilege to execute the statement
   147  drop table system_metrics.process_open_fds;
   148  internal error: do not have privilege to execute the statement
   149  drop table system_metrics.process_max_fds;
   150  internal error: do not have privilege to execute the statement
   151  drop table system_metrics.sys_cpu_seconds_total;
   152  internal error: do not have privilege to execute the statement
   153  drop table system_metrics.sys_cpu_combined_percent;
   154  internal error: do not have privilege to execute the statement
   155  drop table system_metrics.sys_memory_used;
   156  internal error: do not have privilege to execute the statement
   157  drop table system_metrics.sys_memory_available;
   158  internal error: do not have privilege to execute the statement
   159  drop table system_metrics.sys_disk_read_bytes;
   160  internal error: do not have privilege to execute the statement
   161  drop table system_metrics.sys_disk_write_bytes;
   162  internal error: do not have privilege to execute the statement
   163  drop table system_metrics.sys_net_recv_bytes;
   164  internal error: do not have privilege to execute the statement
   165  drop table system_metrics.sys_net_sent_bytes;
   166  internal error: do not have privilege to execute the statement
   167  create table system_metrics.A(a int);
   168  internal error: do not have privilege to execute the statement
   169  update sql_statement_total set type = "1";
   170  invalid input: cannot insert/update/delete from view
   171  update system_metrics.sql_statement_total set type = "1";
   172  invalid input: cannot insert/update/delete from view
   173  insert into sql_statement_total values ("2022-10-09 00:00:00",0,"1","1","1","1");
   174  invalid input: cannot insert/update/delete from view
   175  insert into system_metrics.sql_statement_total values ("2022-10-09 00:00:00",0,"1","1","1","1");
   176  invalid input: cannot insert/update/delete from view
   177  drop table if exists mysql.user;
   178  internal error: do not have privilege to execute the statement
   179  drop table if exists mysql.db;
   180  internal error: do not have privilege to execute the statement
   181  drop table if exists mysql.procs_priv;
   182  internal error: do not have privilege to execute the statement
   183  drop table if exists mysql.columns_priv;
   184  internal error: do not have privilege to execute the statement
   185  drop table if exists mysql.tables_priv;
   186  internal error: do not have privilege to execute the statement
   187  use information_schema;
   188  drop table if exists KEY_COLUMN_USAGE;
   189  internal error: do not have privilege to execute the statement
   190  drop table if exists COLUMNS;
   191  internal error: do not have privilege to execute the statement
   192  drop table if exists PROFILING;
   193  internal error: do not have privilege to execute the statement
   194  drop table if exists `PROCESSLIST`;
   195  internal error: do not have privilege to execute the statement
   196  drop table if exists USER_PRIVILEGES;
   197  internal error: do not have privilege to execute the statement
   198  drop table if exists SCHEMATA;
   199  internal error: do not have privilege to execute the statement
   200  drop table if exists CHARACTER_SETS;
   201  internal error: do not have privilege to execute the statement
   202  drop table if exists TRIGGERS;
   203  internal error: do not have privilege to execute the statement
   204  drop table if exists TABLES;
   205  internal error: do not have privilege to execute the statement
   206  drop table if exists PARTITIONS;
   207  internal error: do not have privilege to execute the statement
   208  create table A(a int);
   209  internal error: do not have privilege to execute the statement
   210  drop table if exists INFORMATION_SCHEMA.KEY_COLUMN_USAGE;
   211  internal error: do not have privilege to execute the statement
   212  drop table if exists INFORMATION_SCHEMA.COLUMNS;
   213  internal error: do not have privilege to execute the statement
   214  drop table if exists INFORMATION_SCHEMA.PROFILING;
   215  internal error: do not have privilege to execute the statement
   216  drop table if exists INFORMATION_SCHEMA.`PROCESSLIST`;
   217  internal error: do not have privilege to execute the statement
   218  drop table if exists INFORMATION_SCHEMA.USER_PRIVILEGES;
   219  internal error: do not have privilege to execute the statement
   220  drop table if exists INFORMATION_SCHEMA.SCHEMATA;
   221  internal error: do not have privilege to execute the statement
   222  drop table if exists INFORMATION_SCHEMA.CHARACTER_SETS;
   223  internal error: do not have privilege to execute the statement
   224  drop table if exists INFORMATION_SCHEMA.TRIGGERS;
   225  internal error: do not have privilege to execute the statement
   226  drop table if exists INFORMATION_SCHEMA.TABLES;
   227  internal error: do not have privilege to execute the statement
   228  drop table if exists INFORMATION_SCHEMA.PARTITIONS;
   229  internal error: do not have privilege to execute the statement
   230  create table INFORMATION_SCHEMA.A(a int);
   231  internal error: do not have privilege to execute the statement
   232  set global enable_privilege_cache = on;