I have some authorization issue while activating Open ODS view in BW .
1.In SAP Hana studio I have created remote source on Hadoop Hive database with user "ABC" and here am successful in creating virtual tables, views and able to data preview also via Smart Data Access.
2.In SAP BW powered by Hana I am trying to create Open ODS View on virtual table via smart data access with user "XYZ" and here am facing insufficient privilege.
Is it mandatory that I have to create both remote source/Open ODS view (Hana/BW) with single user. if not do I need to create the BW user "XYZ" in Hana studio and provide necessary privileges.
Please guide us.