The information is in the attached document (linked below).
NOTE - 8/24/2023 - SAP has changed LTMC such that you can no longer specify the schema where the LTMC tables get created. In addition, the LTMC staging tables are created in the main SAPHANADB schema by default. There are 2 methods to work around this change:
- Specify a "Remote SAP HANA Database Schema" which is basically a different SAP HANA system (this is an unlikely option considering the cost).
- Grant write/update/delete permissions within the main SAPHANADB schema, only to the specific LTMC tables. This is more work since there are 100s of LTMC tables that will get created, but it is still the best option.