cancel
Showing results for 
Search instead for 
Did you mean: 

How to know HANA View Deletion Log

darshansomaiah1
Participant
0 Kudos
1,070

Hi Everyone,

Recently, we faced an issue with the view which was created in a respective package was missing/ deleted. In order to investigate the deletion logs, I could not get the respective information. It was pointing to SAP Admin recovery logs most of the time.

Please suggest on how to get the deletion log of a calculation view in HANA studio.

Thanks,

Regards,

Nachappa

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member183326
Active Contributor
0 Kudos

Hello,

A guess - maybe try looking at _SYS_REPO - OBJECT_HISTORY?

I take it you did not have auditing active?

darshansomaiah1
Participant
0 Kudos

Thanks Michael,

I do not have authorization it seems "SAP DBTech JDBC: [258]:Insufficient privilege: Not authorized"

Is there any chance I can get these details from other schemas like _sys_bic. Please suggest.

Regards,

Nachappa S

former_member183326
Active Contributor
0 Kudos

Not that I am aware off.

Why don't you troubleshoot the 258 error by running an authorisation trace to see which privilege you are missing to view these?

Again this is only a guess in regards to the _SYS_REPO - OBJECT_HISTORY