| ==== |
| ---- 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 |
| ==== |