Forum Discussion
SAP HANA - How to configure SAP-side security
We are successfully connecting to our SAP HANA database but only see a few tables/views (see below) . A commonly-used table such as VBAK (sales order header) does not appear. I've checked with our SAP BASIS team - they cannot find any documentation or guidance on SAP's website on how to setup the SAP-side user, security-wise. Does anyone know of any links to documentation that can be used as a guide?
Thanks in advance!
5 Replies
Anonymous,
I am not very clear about your requirement. Have you checked if the account you use to connect to the database has sufficient permission on the VBAK table? And are you able to view VBAK table when using other applications such as Excel or SAP Hana client to connect to the database?
Regards,
LydiaHello Lydia,
Thanks for the quick reply!. I'm not an SAP HANA security expert so I was suspecting I'd probably need to clarify. And our SAP BASIS team is fairly new to the HANA security thing so we're kinda the blind leading the blind. :)
I'm able to connect to the HANA server successfully and am able to execute a simple SQL query successfully via Advanced options in the server dialog. However, when I actually go to the Navigator (Import OR DirectQuery), only certain table/field structures appear but do not include, for example, VBAK. So I'm looking for guidance or link to documentation as to how that SAP user's permissions should be configured to enable viewing the structure. And yes, we are able to view the table via SE11 using SAP.