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

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