Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cannot get the data provider outline

I was trying to create a analytical view in SAP HANA with the help of following guide.

I could not open data preview and received following error

SAP DBTech JDBC: [391] (at 119): invalidated view

After searching on SDN, I found following solution at

grant select on schema <SCHEMA> to SYSREPO with grant option;

grant select on schema <SCHEMA> to <USER>;

I successfully executed first statement but kept failing to execute second one. I was getting error. After reading the error message and SAP note I realized that I was logged in as SYSTEM so I do not have to execute second statement. I only needed this if I am allowing other users.

Silly, but I learnt something new.

Former Member
Not what you were looking for? View more on this topic or Ask a question