What are the minimum permissions requirement for the Statistica Enterprise Database Migration Utility Tool (SECMU) for the database user for both source and target databases

What are the minimum permissions requirement for the Statistica Enterprise Database Migration Utility Tool (SECMU) for the database user for both source and target databases

book

Article ID: KB0070273

calendar_today

Updated On:

Products Versions
Spotfire Statistica 14.0.1 and higher

Description

The Statistica Enterprise Database Migration Utility Tool  (SECMU) is a powerful tool used for securely migrating data between databases. However, ensuring that proper permissions are in place is crucial for its successful operation. This article aims to assist you in describing the minimum permissions required for a user in both the source and destination databases for database migration.

Issue/Introduction

This Article provides a comprehensive overview of the minimum permissions required for database users to effectively utilize the SECMU (Statistica Enterprise Database Migration Utility Tool ) on both the source and target databases.

Environment

Windows

Resolution

The Statistica Enterprise Database Migration Utility Tool (SECMU) tool is an important component for managing database security and facilitating data migration. The minimum permissions requirements for a database user are: 

1. DELETE Permission: 
 - If you check the "Update access permission on existing objects" option, the tool will delete old permissions, regardless of whether you've selected the "Remove destination permissions that don't exist in the source" option.
User-added image
 - Even if you don't select the "Update access permission on existing objects" option, you still need the DELETE permission to control code and make sure everything runs smoothly without errors.

- Necessary for SECMU tool operations such as removing old permissions, managing data deletions, and ensuring data integrity during migration processes. 

2. UPDATE Permission: 
- The UPDATE permission is necessary for modifying existing data in the database.
- SECMU may require UPDATE permissions when updating access permissions on existing database objects.
- Ensure appropriate UPDATE permissions are granted to the SECMU tool user to facilitate seamless data management operations.

3. INSERT Permission:
- INSERT permission is essential for adding new data records into the database.
- The Migration utility tool might require INSERT permissions when inserting new entries during data migration processes.
- Grant INSERT permissions to the SECMU tool user to enable smooth insertion of data as required.

4. SELECT Permission: 
 
- SELECT permission allows users to retrieve data from the database.
 - The SECMU tool may need SELECT permissions for querying database objects and accessing necessary information during migration and security operations.
 - Ensure adequate SELECT permissions are assigned to the SECMU tool user for efficient data retrieval.


Note: The SQL user must have DELETE permissions, by design.