twonly
commented
4 years ago One more comment, for tenants, suppose we have another user with privilege to select the M_BACKUP_CATALOG but no privilege to modify it (BACKUP ADMIN). Therefore, we might need to use the TenantDB's KEY to retrieve the BACKUP_ID, then use SystemDB's KEY to perform the Housekeeping SQL.
When using the backup (and catalog) clean up function, as we only got one account maintained in SystemDB with BACKUP ADMIN privilege, therefore with the current argument (-dbs) we are not able to perform the housekeeping for TenantDBs (as we don't have BACKUP ADMIN users in each TenantDB). As HANA MDC allows SystemDB to manage the backup for TenantDBs, (SQL demo : backup catalog delete for all before BACKUP_ID [complete]), this might be considered for the above-mentioned scenario.