Skip to Content
0

"insufficient privilege" running backup

May 24, 2017 at 09:03 AM

239

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Werner Flamme May 24, 2017 at 10:34 AM
0

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 :-\

Share
10 |10000 characters needed characters left characters exceeded