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

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