github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/zz_accesscontrol/use_role.result (about)

     1  drop role if exists use_role_1,use_role_2,use_role_3,use_role_4,use_role_5;
     2  drop user if exists use_user_1,use_user_2;
     3  drop database if exists use_db_1;
     4  create role use_role_1,use_role_2,use_role_3,use_role_4,use_role_5;
     5  create database use_db_1;
     6  create user use_user_1 identified by '123456' default role use_role_1;
     7  grant select ,insert ,update on table *.* to use_role_1;
     8  grant all on database * to use_role_2;
     9  grant use_role_2 to use_user_1;
    10  create table use_db_1.use_table_1(a int,b varchar(20),c double );
    11  internal error: do not have privilege to execute the statement
    12  set secondary role all;
    13  create table use_db_1.use_table_1(a int,b varchar(20),c double );
    14  select * from use_db_1.use_table_1;
    15  a    b    c
    16  insert into use_db_1.use_table_1 values(34,'kelly',90.3);
    17  set role use_role_2;
    18  create table use_db_1.use_table_2(a int,b varchar(20),c double );
    19  insert into use_db_1.use_table_2 values(34,'kelly',90.3);
    20  internal error: do not have privilege to execute the statement
    21  select * from use_db_1.use_table_2;
    22  internal error: do not have privilege to execute the statement
    23  set secondary role none;
    24  create table use_db_1.use_table_3(a int,b varchar(20),c double );
    25  insert into use_db_1.use_table_3 values(34,'kelly',90.3);
    26  internal error: do not have privilege to execute the statement
    27  select * from use_db_1.use_table_3;
    28  internal error: do not have privilege to execute the statement
    29  drop table use_db_1.use_table_3;
    30  set role use_role_1;
    31  create table use_db_1.use_table_4(a int,b varchar(20),c double );
    32  internal error: do not have privilege to execute the statement
    33  insert into use_db_1.use_table_2 values(10,'yellow',99.99);
    34  select * from use_db_1.use_table_2;
    35  a    b    c
    36  10    yellow    99.99
    37  drop table use_db_1.use_table_2;
    38  internal error: do not have privilege to execute the statement
    39  set role public;
    40  create table use_db_1.use_table_4(a int,b varchar(20),c double );
    41  internal error: do not have privilege to execute the statement
    42  insert into use_db_1.use_table_2 values(10,'yellow',99.99);
    43  internal error: do not have privilege to execute the statement
    44  select * from use_db_1.use_table_2;
    45  internal error: do not have privilege to execute the statement
    46  drop table use_db_1.use_table_2;
    47  internal error: do not have privilege to execute the statement
    48  set secondary role all;
    49  create table use_db_1.use_table_5(a int,b varchar(20),c double );
    50  insert into use_db_1.use_table_5 values(10,'yellow',99.99);
    51  select * from use_db_1.use_table_5;
    52  a    b    c
    53  10    yellow    99.99
    54  drop table use_db_1.use_table_5;
    55  set role moadmin;
    56  internal error: the role moadmin has not be granted to the user use_user_1
    57  create user use_user_2 identified by '123456';
    58  grant create user, drop user, alter user, create role, drop role, create database,drop database,show databases on account *  to use_role_3;
    59  grant all on table *.* to use_role_4;
    60  grant create table,drop table on database * to use_role_5;
    61  grant use_role_3,use_role_4,use_role_5 to use_user_2;
    62  set role use_not_exists;
    63  internal error: there is no role use_not_exists
    64  set role use_role_3;
    65  internal error: the role use_role_3 has not be granted to the user use_user_1
    66  create role use_role_test;
    67  internal error: do not have privilege to execute the statement
    68  set role use_role_test;
    69  internal error: there is no role use_role_test
    70  drop role  use_role_test;
    71  internal error: do not have privilege to execute the statement
    72  set secondary role all;
    73  create table use_db_1.use_table_6(a int,b varchar(20),c double);
    74  insert into use_db_1.use_table_6 values(10,'yellow',99.99);
    75  create database use_db_test;
    76  internal error: do not have privilege to execute the statement
    77  drop database use_db_test;
    78  internal error: do not have privilege to execute the statement
    79  set secondary role none;
    80  insert into use_db_1.use_table_6 values (10, 'yellow', 99.99);
    81  internal error: do not have privilege to execute the statement
    82  drop table use_db_1.use_table_6;
    83  internal error: do not have privilege to execute the statement
    84  create role if not exists use_role_test;
    85  internal error: do not have privilege to execute the statement
    86  drop role use_role_test;
    87  internal error: do not have privilege to execute the statement
    88  set role use_role_5;
    89  internal error: the role use_role_5 has not be granted to the user use_user_1
    90  drop table use_db_1.use_table_6;
    91  internal error: do not have privilege to execute the statement
    92  create database if not exists use_db_test;
    93  internal error: do not have privilege to execute the statement
    94  drop role if exists use_role_1,use_role_2,use_role_3,use_role_4,use_role_5;
    95  drop user if exists use_user_1,use_user_2;
    96  drop database if exists use_db_1;