grant query rewrite to user1;
grant create materialized view to user1;
Make sure:
SYSTEM> show parameter query
NAME TYPE VALUE
------------------------------ ----------- ------------------
query_rewrite_enabled string TRUE
