blob: 55ba28fd1c0e1d93b3fe179d45b6617d918311d4 [file] [log] [blame]
====
---- QUERY
show grant user $USER on database $DATABASE
---- RESULTS
'USER','$USER','database','$DATABASE','','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
does_not_exist
---- QUERY
show grant user does_not_exist
---- CATCH
User 'does_not_exist' does not exist
====
---- USER
user_1group
---- QUERY
show grant user user_2group
---- CATCH
User 'user_1group' does not have privileges to access
====
---- QUERY
show grant user user_1group
---- RESULTS
====
---- QUERY
show grant user user_2group
---- RESULTS
====
---- QUERY
show grant user user1_shared
---- RESULTS
====
---- QUERY
show grant user user2_shared
---- RESULTS
====
---- QUERY
show grant user user1_shared2
---- RESULTS
====
---- QUERY
show grant user user2_shared2
---- RESULTS
====
---- QUERY
create role sgu_test_create_role;
grant create on database $DATABASE to role sgu_test_create_role;
grant role sgu_test_create_role to group group_1;
grant role sgu_test_create_role to group group_2a;
grant role sgu_test_create_role to group group_2b;
grant role sgu_test_create_role to group group_3;
grant role sgu_test_create_role to group group_4a;
grant role sgu_test_create_role to group group_4b;
====
---- USER
user_1group
---- QUERY
create table $DATABASE.user_1group_tbl (col1 int);
====
---- USER
user_2group
---- QUERY
create table $DATABASE.user_2group_tbl (col1 int);
====
---- USER
user1_shared
---- QUERY
create table $DATABASE.user1_shared_tbl (col1 int);
====
---- USER
user2_shared
---- QUERY
create table $DATABASE.user2_shared_tbl (col1 int);
====
---- USER
user1_shared2
---- QUERY
create table $DATABASE.user1_shared2_tbl (col1 int);
====
---- USER
user2_shared2
---- QUERY
create table $DATABASE.user2_shared2_tbl (col1 int);
====
---- QUERY
drop role sgu_test_create_role
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_1group
---- QUERY
show grant user user_1group on table $DATABASE.user_1group_tbl
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
create role sgu_test_role1_group1;
grant role sgu_test_role1_group1 to group group_1;
create role sgu_test_role1_group2a;
grant role sgu_test_role1_group2a to group group_2a;
create role sgu_test_role1_group2b;
grant role sgu_test_role1_group2b to group group_2b;
create role sgu_test_role1_group3;
grant role sgu_test_role1_group3 to group group_3;
create role sgu_test_role1_group4a;
grant role sgu_test_role1_group4a to group group_4a;
create role sgu_test_role1_group4b;
grant role sgu_test_role1_group4b to group group_4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
grant select on table $DATABASE.user_1group_tbl to role sgu_test_role1_group1;
grant insert on table $DATABASE.user_2group_tbl to role sgu_test_role1_group2a;
grant alter on table $DATABASE.user_2group_tbl to role sgu_test_role1_group2b;
grant drop on table $DATABASE.user1_shared_tbl to role sgu_test_role1_group3;
grant refresh on table $DATABASE.user2_shared_tbl to role sgu_test_role1_group3;
grant all on table $DATABASE.user1_shared2_tbl to role sgu_test_role1_group4a;
grant select on table $DATABASE.user2_shared2_tbl to role sgu_test_role1_group4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl','','','insert',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl','','','alter',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
create table $DATABASE.user_1group_tbl2 (col1 int);
create table $DATABASE.user_2group_tbl2 (col1 int);
create table $DATABASE.user1_shared_tbl2 (col1 int);
create table $DATABASE.user2_shared_tbl2 (col1 int);
create table $DATABASE.user1_shared2_tbl2 (col1 int);
create table $DATABASE.user2_shared2_tbl2 (col1 int);
grant insert on table $DATABASE.user_1group_tbl2 to role sgu_test_role1_group1;
grant select on table $DATABASE.user_2group_tbl2 to role sgu_test_role1_group2a;
grant drop on table $DATABASE.user_2group_tbl2 to role sgu_test_role1_group2b;
grant alter on table $DATABASE.user1_shared_tbl2 to role sgu_test_role1_group3;
grant select on table $DATABASE.user2_shared_tbl2 to role sgu_test_role1_group3;
grant select on table $DATABASE.user1_shared2_tbl2 to role sgu_test_role1_group4a;
grant insert on table $DATABASE.user2_shared2_tbl2 to role sgu_test_role1_group4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl2','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl','','','insert',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl2','','','drop',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl2','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
create role sgu_test_role2_group1;
grant role sgu_test_role2_group1 to group group_1;
create role sgu_test_role2_group2a;
grant role sgu_test_role2_group2a to group group_2a;
create role sgu_test_role2_group2b;
grant role sgu_test_role2_group2b to group group_2b;
create role sgu_test_role2_group3;
grant role sgu_test_role2_group3 to group group_3;
create role sgu_test_role2_group4a;
grant role sgu_test_role2_group4a to group group_4a;
create role sgu_test_role2_group4b;
grant role sgu_test_role2_group4b to group group_4b;
create table $DATABASE.user_1group_tbl3 (col1 int);
create table $DATABASE.user_2group_tbl3 (col1 int);
create table $DATABASE.user1_shared_tbl3 (col1 int);
create table $DATABASE.user2_shared_tbl3 (col1 int);
create table $DATABASE.user1_shared2_tbl3 (col1 int);
create table $DATABASE.user2_shared2_tbl3 (col1 int);
grant select on table $DATABASE.user_1group_tbl3 to role sgu_test_role2_group1;
grant insert on table $DATABASE.user_2group_tbl3 to role sgu_test_role2_group2a;
grant alter on table $DATABASE.user_2group_tbl3 to role sgu_test_role2_group2b;
grant drop on table $DATABASE.user1_shared_tbl3 to role sgu_test_role2_group3;
grant insert on table $DATABASE.user2_shared_tbl3 to role sgu_test_role2_group3;
grant select on table $DATABASE.user1_shared2_tbl3 to role sgu_test_role2_group4a;
grant alter on table $DATABASE.user2_shared2_tbl3 to role sgu_test_role2_group4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl2','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group1','table','$DATABASE','user_1group_tbl3','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl','','','insert',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl2','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group2a','table','$DATABASE','user_2group_tbl3','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group2b','table','$DATABASE','user_2group_tbl3','','','alter',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user1_shared_tbl3','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user2_shared_tbl3','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user1_shared_tbl3','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user2_shared_tbl3','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl2','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group4a','table','$DATABASE','user1_shared2_tbl3','','','select',false,regex:.+
'ROLE','sgu_test_role2_group4b','table','$DATABASE','user2_shared2_tbl3','','','alter',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role2_group4a','table','$DATABASE','user1_shared2_tbl3','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
create table $DATABASE.user_1group_tbl4 (col1 int);
create table $DATABASE.user_2group_tbl4 (col1 int);
create table $DATABASE.user1_shared_tbl4 (col1 int);
create table $DATABASE.user2_shared_tbl4 (col1 int);
create table $DATABASE.user1_shared2_tbl4 (col1 int);
create table $DATABASE.user2_shared2_tbl4 (col1 int);
grant select on table $DATABASE.user_1group_tbl4 to role sgu_test_role2_group1;
grant insert on table $DATABASE.user_2group_tbl4 to role sgu_test_role2_group2a;
grant alter on table $DATABASE.user_2group_tbl4 to role sgu_test_role2_group2b;
grant drop on table $DATABASE.user1_shared_tbl4 to role sgu_test_role2_group3;
grant insert on table $DATABASE.user2_shared_tbl4 to role sgu_test_role2_group3;
grant select on table $DATABASE.user1_shared2_tbl4 to role sgu_test_role2_group4a;
grant alter on table $DATABASE.user2_shared2_tbl4 to role sgu_test_role2_group4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl2','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group1','table','$DATABASE','user_1group_tbl3','','','select',false,regex:.+
'ROLE','sgu_test_role2_group1','table','$DATABASE','user_1group_tbl4','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl','','','insert',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl2','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group2a','table','$DATABASE','user_2group_tbl3','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group2b','table','$DATABASE','user_2group_tbl3','','','alter',false,regex:.+
'ROLE','sgu_test_role2_group2a','table','$DATABASE','user_2group_tbl4','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group2b','table','$DATABASE','user_2group_tbl4','','','alter',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user1_shared_tbl3','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user2_shared_tbl3','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user1_shared_tbl4','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user2_shared_tbl4','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user1_shared_tbl3','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user2_shared_tbl3','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user1_shared_tbl4','','','drop',false,regex:.+
'ROLE','sgu_test_role2_group3','table','$DATABASE','user2_shared_tbl4','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl2','','','insert',false,regex:.+
'ROLE','sgu_test_role2_group4a','table','$DATABASE','user1_shared2_tbl3','','','select',false,regex:.+
'ROLE','sgu_test_role2_group4b','table','$DATABASE','user2_shared2_tbl3','','','alter',false,regex:.+
'ROLE','sgu_test_role2_group4a','table','$DATABASE','user1_shared2_tbl4','','','select',false,regex:.+
'ROLE','sgu_test_role2_group4b','table','$DATABASE','user2_shared2_tbl4','','','alter',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role2_group4a','table','$DATABASE','user1_shared2_tbl3','','','select',false,regex:.+
'ROLE','sgu_test_role2_group4a','table','$DATABASE','user1_shared2_tbl4','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
drop role sgu_test_role2_group1;
drop role sgu_test_role2_group2a;
drop role sgu_test_role2_group2b;
drop role sgu_test_role2_group3;
drop role sgu_test_role2_group4a;
drop role sgu_test_role2_group4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl2','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl','','','insert',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl2','','','drop',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl2','','','alter',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl2','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl2','','','insert',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl2','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
revoke insert on table $DATABASE.user_1group_tbl2 from role sgu_test_role1_group1;
revoke select on table $DATABASE.user_2group_tbl2 from role sgu_test_role1_group2a;
revoke drop on table $DATABASE.user_2group_tbl2 from role sgu_test_role1_group2b;
revoke alter on table $DATABASE.user1_shared_tbl2 from role sgu_test_role1_group3;
revoke select on table $DATABASE.user2_shared_tbl2 from role sgu_test_role1_group3;
revoke select on table $DATABASE.user1_shared2_tbl2 from role sgu_test_role1_group4a;
revoke insert on table $DATABASE.user2_shared2_tbl2 from role sgu_test_role1_group4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'USER','user_1group','table','$DATABASE','user_1group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'USER','user_2group','table','$DATABASE','user_2group_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl','','','insert',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl','','','alter',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'USER','user1_shared','table','$DATABASE','user1_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'USER','user2_shared','table','$DATABASE','user2_shared_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'USER','user1_shared2','table','$DATABASE','user1_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'USER','user2_shared2','table','$DATABASE','user2_shared2_tbl','','','owner',true,regex:.+
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
drop table $DATABASE.user_1group_tbl;
drop table $DATABASE.user_2group_tbl;
drop table $DATABASE.user1_shared_tbl;
drop table $DATABASE.user2_shared_tbl;
drop table $DATABASE.user1_shared2_tbl;
drop table $DATABASE.user2_shared2_tbl;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
'ROLE','sgu_test_role1_group1','table','$DATABASE','user_1group_tbl','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
'ROLE','sgu_test_role1_group2a','table','$DATABASE','user_2group_tbl','','','insert',false,regex:.+
'ROLE','sgu_test_role1_group2b','table','$DATABASE','user_2group_tbl','','','alter',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
'ROLE','sgu_test_role1_group3','table','$DATABASE','user1_shared_tbl','','','drop',false,regex:.+
'ROLE','sgu_test_role1_group3','table','$DATABASE','user2_shared_tbl','','','refresh',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
'ROLE','sgu_test_role1_group4b','table','$DATABASE','user2_shared2_tbl','','','select',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
'ROLE','sgu_test_role1_group4a','table','$DATABASE','user1_shared2_tbl','','','all',false,regex:.+
---- TYPES
STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BOOLEAN, STRING
====
---- QUERY
drop role sgu_test_role1_group1;
drop role sgu_test_role1_group2a;
drop role sgu_test_role1_group2b;
drop role sgu_test_role1_group3;
drop role sgu_test_role1_group4a;
drop role sgu_test_role1_group4b;
====
---- USER
user_1group
---- QUERY
show grant user user_1group
---- RESULTS
====
---- USER
user_2group
---- QUERY
show grant user user_2group
---- RESULTS
====
---- USER
user1_shared
---- QUERY
show grant user user1_shared
---- RESULTS
====
---- USER
user2_shared
---- QUERY
show grant user user2_shared
---- RESULTS
====
---- USER
user1_shared2
---- QUERY
show grant user user1_shared2
---- RESULTS
====
---- USER
user2_shared2
---- QUERY
show grant user user2_shared2
---- RESULTS
====