Privillage issue

[Former Member]

MY views are successfully validating and activating but when i click on data preview i'm getting below error

I tried with this sql query

GRANT SELECT ON SCHEMA <SCHEMANAME> TO REPOSITORY NAME

GRANT SELECT ON SCHEMA HANAUSER TO "_SYS_REPO";

BEFORE I  execute this query my views are not activated now my views are activating but i'm getting below error while clicking on data preview

[patrickbachmann]

1) I'm assuming the user doing the data preview is not the same user that modeled the view?

2) If above is true make sure this user has access to the package and any Analytic Privilege that may be associated with that view.

-Patrick

[Former Member]

Thank you