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

     1  set global enable_privilege_cache = off;
     2  drop account if exists accx;
     3  create account accx admin_name 'xcca' identified by '111';
     4  drop role if exists rolex;
     5  create role rolex;
     6  drop user if exists userx,root,dump;
     7  create user userx identified by '111',root identified by '111',dump identified by '111';
     8  grant accountadmin to xcca;
     9  grant accountadmin to userx;
    10  internal error: the role accountadmin can not be granted to non administration user userx
    11  grant accountadmin to root;
    12  internal error: the role accountadmin can not be granted to non administration user root
    13  grant accountadmin to dump;
    14  internal error: the role accountadmin can not be granted to non administration user dump
    15  grant accountadmin to rolex;
    16  internal error: the role accountadmin can not be granted to the other role rolex
    17  grant rolex to accountadmin;
    18  internal error: the role rolex can not be granted to the role accountadmin
    19  grant public to xcca;
    20  grant public to userx;
    21  grant public to rolex;
    22  internal error: the role public can not be granted to the other role rolex
    23  grant rolex to public;
    24  internal error: the role rolex can not be granted to the role public
    25  revoke accountadmin from xcca;
    26  internal error: the role accountadmin can not be revoked
    27  revoke accountadmin from userx;
    28  internal error: the role accountadmin can not be revoked
    29  revoke accountadmin from root;
    30  internal error: the role accountadmin can not be revoked
    31  revoke accountadmin from dump;
    32  internal error: the role accountadmin can not be revoked
    33  revoke accountadmin from rolex;
    34  internal error: the role accountadmin can not be revoked
    35  revoke rolex from accountadmin;
    36  internal error: the role rolex can not be revoked from the role accountadmin
    37  revoke public from xcca;
    38  internal error: the role public can not be revoked
    39  revoke public from userx;
    40  internal error: the role public can not be revoked
    41  revoke public from root;
    42  internal error: the role public can not be revoked
    43  revoke public from dump;
    44  internal error: the role public can not be revoked
    45  revoke public from rolex;
    46  internal error: the role public can not be revoked
    47  revoke rolex from public;
    48  internal error: the role rolex can not be revoked from the role public
    49  grant show databases,create database on account * to accountadmin;
    50  internal error: the privilege can not be granted to the role accountadmin
    51  revoke show databases,create database on account * from accountadmin;
    52  internal error: the privilege can not be revoked from the role accountadmin
    53  revoke connect on account * from public;
    54  internal error: the privilege connect can not be revoked from the role public
    55  revoke show databases on account * from public;
    56  create role accountadmin;
    57  internal error: can not use the name accountadmin. it is the name of the predefined role
    58  create role moadmin;
    59  internal error: can not use the name moadmin. it is the name of the predefined role
    60  drop role rolex;
    61  drop user userx,root,dump;
    62  drop account if exists accx;
    63  set global enable_privilege_cache = on;