When you connect to a Management Service using the CAST Transaction Configuration Center, you must specify a User name. This User name requires the following access rights for the server and the Management Service:
- Read tables
- Write to tables
- Execute stored procedures
As such, CAST recommends that you re-use the same user specified in the Connection Profile used when launching the CAST Management Studio.
Notes - Note that in a CAST Storage Service environment, rights do NOT need to be managed. The default operator user already has the required rights to connect to a Management database.
Interaction with other CAST databases
The CAST Transaction Configuration Center requires access to the CAST Analysis Service as part of general usage. However, the application will re-use Analysis Service login information stored in the CAST Management Service and as such the connection to the Analysis Service is seamless and does not require any user interaction.
CAST recommends, however, that you read the CAST Management Studio integrated help on Server Access rights and ensure that the user you are using in the CAST Management Studio to connect to the Analysis Service has sufficient rights.