SAP SE
PRIVILEGE RETENTION FOR DATABASE MIGRATION

Abstract:

Disclosed herein are system, method, and computer program product embodiments for performing a database migration with automatic privilege retention and restoration. Embodiments provide for migrating a source database object at a source database to a target database object at a target database. The embodiments provide for binding a retention tag to database objects in order to mark the objects whose privileges are to be retained during a database migration. This approach enables privileges of database objects that are involved in a database migration to be automatically restored at target database objects after the migration.