How to apply Authorization Trace in SAP HANA

Trace files are used to troubleshoot problems in the SAP HANA Systems. Trace files containing useful information for error analysis.

Reason: When query a view or performing data preview you receive error. To find the particular missing authorization.

For performing Trace activity. You should have TRACE ADMIN System privileges.

How to use Authorization trace:

1- Activate the trace for a specific user.

2- Reproduce the error with the affected user

3- Analyze the trace file

4- Deactivate the trace

Activate authorization trace for specific user:

Connect to System via HANA studio.

Right click on System -> Configuration and Monitoring -> Open Administration

Open Trace Configuration tab.

Click on User Specific trace.

Specify the Database User and optionally a context name. Select Trace Level "info" for component global/indexserver

Select Finish.

Trace has been activated for user successfully.

Now reproduce the error with affected user.