Hi @shsalami ,
According to below documentation snippet, you also need USE CATALOG privilege on the parent catalog.
"The user who creates a materialized view (MV) is the MV owner and needs to have the following permissions:
- SELECT privilege over the base tables referenced by the MV.
- USE CATALOG privilege on the parent catalog and the USE SCHEMA privilege on the parent schema.
- CREATE MATERIALIZED VIEW privilege on the schema for the MV."