cancel
Showing results for 
Search instead for 
Did you mean: 

"insufficient privilege" running backup

werner_flamme
Explorer
0 Kudos

Hi everyone, I to run the script from SAPnote 1651055 on a HANA 1.0 SP12 and it works. Now I tried this script on a HANA 2.0 and it stops when running the command

backup catalog delete all before BACKUP_ID 1495509600083 WITH FILE;

telling me

* 258: insufficient privilege: Not authorized SQLSTATE: HY000

I added "backup admin" privilege to the backup user, but the error remains. What am I missing?

Accepted Solutions (0)

Answers (1)

Answers (1)

werner_flamme
Explorer
0 Kudos

OK - it took an hour, but the error has gone. The script runs when the BackupUser has BACKUP ADMIN privileges, BACKUP OPERATOR is not sufficient any more.

Why it took an hour (without modifying the user in any way) is not explainable for me 😕