After you followed Note 2299622 to creat an intermediate data preview, an error "SAP DBTech JDBC: : insufficient privilege: Not authorized."pops out when you click on any intermediate views and select Data Preview.
In the indexserver trace you can see following error:User XXXX is missing privilege DROP for VIEW _SYS_BIC.ABC.ABC/XXXX/dp/Projectiion_2User XXXX is missing privilege CREATE ANY for SCHEMA _SYS_BIC
HANA Database 1.0 Revision 122.08 or lower (SPS12)
KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.