I have a OLAP connection against HANA, the connection was working fine but the user that was set in the connection was removed from HANA studio (nobody knew) and now we are facing some issues to access the cubes.
I have setup another user but it doesn't work because I think that is missing to add some permissions to the user for HANA.
I am using pre-defined authentication and when I use SYSTEM user it works perfectly.
In this context, my questions are:
1. Is a good practice to set the SYSTEM user for these connections? I don't know if setting the SYSTEM user, I am having any security or any other issue in a future.
2. If Question 1 is no, What are the permissions that I have to add to the user from HANA Studio?
I look forward any suggestion,