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

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