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

     1  set global enable_privilege_cache = on;
     2  drop user if exists u1;
     3  drop role if exists r1;
     4  create user u1 identified by '111';
     5  create role r1;
     6  grant r1 to u1;
     7  show variables like 'enable_privilege_cache';
     8  Variable_name    Value
     9  enable_privilege_cache    on
    10  show databases;
    11  internal error: do not have privilege to execute the statement
    12  grant show databases on account * to r1;
    13  show databases;
    14  Database
    15  cache
    16  information_schema
    17  mo_catalog
    18  mo_debug
    19  mo_task
    20  mysql
    21  system
    22  system_metrics
    23  revoke show databases on account * from r1;
    24  show variables like 'enable_privilege_cache';
    25  Variable_name    Value
    26  enable_privilege_cache    on
    27  show databases;
    28  Database
    29  cache
    30  information_schema
    31  mo_catalog
    32  mo_debug
    33  mo_task
    34  mysql
    35  system
    36  system_metrics
    37  show databases;
    38  Database
    39  cache
    40  information_schema
    41  mo_catalog
    42  mo_debug
    43  mo_task
    44  mysql
    45  system
    46  system_metrics
    47  set clear_privilege_cache = on;
    48  show variables like 'clear_privilege_cache';
    49  Variable_name    Value
    50  clear_privilege_cache    on
    51  show variables like 'enable_privilege_cache';
    52  Variable_name    Value
    53  enable_privilege_cache    on
    54  show databases;
    55  internal error: do not have privilege to execute the statement
    56  show databases;
    57  internal error: do not have privilege to execute the statement
    58  grant show databases on account * to r1;
    59  show databases;
    60  Database
    61  cache
    62  information_schema
    63  mo_catalog
    64  mo_debug
    65  mo_task
    66  mysql
    67  system
    68  system_metrics
    69  show databases;
    70  Database
    71  cache
    72  information_schema
    73  mo_catalog
    74  mo_debug
    75  mo_task
    76  mysql
    77  system
    78  system_metrics
    79  revoke show databases on account * from r1;
    80  set enable_privilege_cache = off;
    81  show variables like 'clear_privilege_cache';
    82  Variable_name    Value
    83  clear_privilege_cache    on
    84  show variables like 'enable_privilege_cache';
    85  Variable_name    Value
    86  enable_privilege_cache    off
    87  show databases;
    88  internal error: do not have privilege to execute the statement
    89  show databases;
    90  internal error: do not have privilege to execute the statement
    91  grant show databases on account * to r1;
    92  show databases;
    93  Database
    94  cache
    95  information_schema
    96  mo_catalog
    97  mo_debug
    98  mo_task
    99  mysql
   100  system
   101  system_metrics
   102  revoke show databases on account * from r1;
   103  show databases;
   104  internal error: do not have privilege to execute the statement
   105  show databases;
   106  internal error: do not have privilege to execute the statement
   107  drop user if exists u1;
   108  drop user if exists r1;
   109  set clear_privilege_cache = on;
   110  set global enable_privilege_cache = on;