szymon_dybczak
Esteemed Contributor III

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."