Products | Versions |
---|---|
Spotfire Statistica | 14.0.1 and higher |
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.
- 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.