blob: 792b851e8542b03c3cbbe4dd300f87c2ba4943e9 [file] [log] [blame]
--! qt:authorizer
set user.name=user1;
create table amvro_table (a int, b varchar(256), c decimal(10,2));
insert into amvro_table values (1, 'alfred', 10.30),(2, 'bob', 3.14),(2, 'bonnie', 172342.2),(3, 'calvin', 978.76),(3, 'charlie', 9.8);
create materialized view amvro_mat_view disable rewrite as select a, c from amvro_table;
set user.name=user2;
alter materialized view amvro_mat_view rebuild;