github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/zz_accesscontrol/revoke_privs_role.result (about) 1 drop database if exists revoke_db_01; 2 drop role if exists revoke_role_1,revoke_role_2,revoke_role_3,revoke_role_4,revoke_role_5,revoke_role_6,revoke_role_7,revoke_role_8; 3 drop user if exists revoke_user_1,revoke_user_2,revoke_user_3,revoke_user_4,revoke_user_5,revoke_user_6,revoke_user_7; 4 create role if not exists revoke_role_1,revoke_role_2,revoke_role_3,revoke_role_4,revoke_role_5,revoke_role_6,revoke_role_7,revoke_role_8; 5 create user if not exists revoke_user_1 identified by '12345678',revoke_user_2 identified by '12345678',revoke_user_3 identified by '12345678',revoke_user_4 identified by '12345678',revoke_user_5 identified by '12345678',revoke_user_6 identified by '12345678',revoke_user_7 identified by '12345678'; 6 create database revoke_db_01; 7 grant create user, drop user, alter user, create role, drop role, create database,drop database on account * to revoke_role_1 with grant option; 8 grant revoke_role_1 to revoke_user_1; 9 revoke create user, drop user, alter user on account * from revoke_role_1; 10 select role_name, privilege_name, privilege_level from mo_catalog.mo_role_privs where role_name='revoke_role_1'; 11 role_name privilege_name privilege_level 12 revoke_role_1 create role * 13 revoke_role_1 drop role * 14 revoke_role_1 create database * 15 revoke_role_1 drop database * 16 create user re_test_user identified by '12345678'; 17 internal error: do not have privilege to execute the statement 18 drop user re_test_user; 19 internal error: do not have privilege to execute the statement 20 create role revoke_role_9; 21 drop role revoke_role_9; 22 revoke all on account * from revoke_role_3; 23 revoke create user, drop user, show tables on account * from revoke_role_1; 24 internal error: the privilege "show tables" can only be granted to the object type "database" 25 revoke create user, drop user, show tables on table *.* from revoke_role_1; 26 internal error: the privilege "create user" can only be granted to the object type "account" 27 revoke create user, drop user on account * from re_not_exists; 28 internal error: there is no role re_not_exists 29 revoke all on account * from revoke_role_1; 30 grant create table,drop table,alter table on database *.* to revoke_role_2,revoke_role_3 with grant option; 31 grant all on account * to revoke_role_2; 32 grant revoke_role_2 to revoke_user_2; 33 grant revoke_role_3 to revoke_user_3; 34 revoke drop table,create table on database *.* from revoke_role_2,revoke_role_3; 35 select role_name, privilege_name, privilege_level from mo_catalog.mo_role_privs where role_name in ('revoke_role_2','revoke_role_3'); 36 role_name privilege_name privilege_level 37 revoke_role_2 alter table *.* 38 revoke_role_3 alter table *.* 39 revoke_role_2 account all * 40 create table revoke_db_01.revoke_table_1(a int,b varchar(20),c double); 41 internal error: do not have privilege to execute the statement 42 drop table revoke_db_01.revoke_table_1; 43 internal error: do not have privilege to execute the statement 44 create database revoke_db_02; 45 drop database revoke_db_02; 46 create table revoke_db_01.revoke_table_1(a int,b varchar(20),c double); 47 internal error: do not have privilege to execute the statement 48 drop table revoke_db_01.revoke_table_1; 49 internal error: do not have privilege to execute the statement 50 revoke create table,select,insert on database * from revoke_role_2,revoke_role_3; 51 internal error: the privilege "select" can only be granted to the object type "table" 52 revoke if exists create table,select,insert on database * from revoke_role_2,revoke_role_3; 53 internal error: the privilege "select" can only be granted to the object type "table" 54 revoke all on account * from revoke_role_2,revoke_role_3; 55 revoke if exists all on account * from revoke_role_2,revoke_role_3; 56 grant all on table *.* to revoke_role_4,revoke_role_5 with grant option; 57 grant create table,drop table,alter table on database *.* to revoke_role_5; 58 grant revoke_role_4 to revoke_user_4 with grant option; 59 grant revoke_role_5 to revoke_user_5; 60 revoke all on table *.* from revoke_role_4,revoke_role_5; 61 select role_name, privilege_name, privilege_level from mo_catalog.mo_role_privs where role_name in ('revoke_role_4','revoke_role_5'); 62 role_name privilege_name privilege_level 63 revoke_role_5 create table *.* 64 revoke_role_5 drop table *.* 65 revoke_role_5 alter table *.* 66 select * from mo_catalog.mo_user; 67 internal error: do not have privilege to execute the statement 68 select * from mo_catalog.mo_user; 69 internal error: do not have privilege to execute the statement 70 create table revoke_db_01.revoke_table_2(a int,b varchar(20),c double); 71 internal error: do not have privilege to execute the statement 72 drop table revoke_db_01.revoke_table_2; 73 internal error: do not have privilege to execute the statement 74 grant ownership on database revoke_db_01 to revoke_role_6; 75 grant all on table *.* to revoke_role_6; 76 grant revoke_role_6 to revoke_user_6; 77 revoke ownership on database revoke_db_01 from revoke_role_6; 78 create table revoke_test_table_1(a int); 79 internal error: do not have privilege to execute the statement 80 drop table revoke_test_table_1; 81 internal error: do not have privilege to execute the statement 82 grant ownership on database revoke_db_01 to revoke_role_7; 83 internal error: do not have privilege to execute the statement 84 select * from revoke_db_01.revoke_table_1; 85 SQL parser error: table "revoke_table_1" does not exist 86 drop database if exists revoke_db_01; 87 drop role if exists revoke_role_1,revoke_role_2,revoke_role_3,revoke_role_4,revoke_role_5,revoke_role_6,revoke_role_7,revoke_role_8; 88 drop user if exists revoke_user_1,revoke_user_2,revoke_user_3,revoke_user_4,revoke_user_5,revoke_user_6,revoke_user_7; 89