cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA User Authorization

hsnmustafa
Explorer
0 Kudos

Dears,

I am having a strange problem in SAP HANA, my user has all the access in our HANA cloud environment, yesterday i was able to access all the tables in one schema, today suddenly i have access to no table at all. There has been not a single change in security, i confirmed twice.

Plus this has happened earlier also, we had to make another user , just copy the same user, it had all the access. not sure what is happening, can you guys please help us in this.

There is one thing to note, i can access perfectly everything in catalog view, in editor view where i have to create calc views, there i cannot see any table when i click on projection to add a table.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

In such a case, I would recommend to make an authorization trace.

Please enable authorization trace according to

https://wiki.scn.sap.com/wiki/display/SAPHANA/Troubleshooting+SAP+HANA+Privileges+and+Authorisations

++++++++++++++++++++++++++

1. Enable the HANA authorization trace:

alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','authorization')='info' with reconfigure

2. Reproduce the issue.

3. Turn off the trace:

alter system alter configuration ('indexserver.ini','SYSTEM') UNSET ('trace','authorization')with reconfigure

After that please collect the indexserver trace files from HANA Studio during the time when you reproduced the error and check the content related to authorization errors.