SAP Knowledge Base Article - Preview

2332827 - Using dbbackup with -x cannot be done without MANAGE ANY DBSPACE privilege

Symptom

  • Would like all users to be able to perform a database backup (each user has the BACKUP DATABASE privilege).
  • If dbbackup runs with the -x parameter you cannot delete the renamed copy of the transaction log.
  • The MANAGE ANY DBSPACE privilege will be needed to delete the rename copy of the transaction log. 
  • Giving this privilege to each user is not an option since it will give the user too much control over the whole database.


Read more...

Environment

SAP SQL Anywhere 16.x

Product

SAP SQL Anywhere 16.0

Keywords

Sybase, SA, MANGAE ANY DBSPACE, privilege, permissions, dbbackup, -x, database users, DBA , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.