Actions100
- Project Actions
- Project Accept Project Invite
- Project Create Project Invite
- Project List Invites For Project
- Project Create Project
- Project Decline Project Invite
- Project Delete Project Avatar
- Project Request Project Avatar Upload
- Project Delete Project Invite
- Project Get Project Invite
- Project Delete Project Membership
- Project Get Project Membership
- Project Update Project Membership
- Project Delete Project
- Project Get Project
- Project Delete Server Avatar
- Project Request Server Avatar Upload
- Project Get Project Token Invite
- Project Get Self Membership For Project
- Project Get Server
- Project List Memberships For Project
- Project List Project Invites
- Project List Project Memberships
- Project List Projects
- Project List Servers
- Project Resend Project Invite Mail
- Project Update Project Description
- Project Update Server Description
- Storagespace Get Project Statistics
- Storagespace Get Server Statistics
- Storagespace Replace Project Notification Threshold
- Storagespace Replace Server Notification Threshold
- Backup Actions
- Backup Create Project Backup Export
- Backup Delete Project Backup Export
- Backup Create Project Backup Schedule
- Backup List Project Backup Schedules
- Backup Create Project Backup
- Backup List Project Backups
- Backup Delete Project Backup Schedule
- Backup Get Project Backup Schedule
- Backup Update Project Backup Schedule
- Backup Delete Project Backup
- Backup Get Project Backup
- Backup Update Project Backup Description
- SSH SFTP User Actions
- Cronjob Actions
- App Actions
- App Execute Action
- App Get App
- App Get Appinstallation
- App Patch Appinstallation
- App Uninstall Appinstallation
- App Get Appversion
- App Get Installed Systemsoftware For Appinstallation
- App Get Missing Dependencies For Appinstallation
- App Get Systemsoftware
- App Get Systemsoftwareversion
- App Link Database
- App List Appinstallations For User
- App List Appinstallations
- App Request Appinstallation
- App List Apps
- App List Appversions
- App List Systemsoftwares
- App List Systemsoftwareversions
- App List Update Candidates For Appversion
- App Replace Database
- App Request Appinstallation Copy
- App Retrieve Status
- App Unlink Database
- App Set Database Users
- Project File System Actions
- Contract Actions
Overview
This node interacts with the mittwald mStudio API to set database users for a specific app installation. It allows you to assign or update which users have access to a particular database within an app installation. This is useful in scenarios where you manage multiple apps and databases and need to programmatically control user permissions or access rights.
Practical examples include:
- Automating user access management when provisioning new app installations.
- Synchronizing database user assignments based on external user management systems.
- Updating database user lists as part of deployment or maintenance workflows.
Properties
| Name | Meaning |
|---|---|
| App Installation Id | The unique identifier of the app installation for which database users are being set. |
| Database Id | The unique identifier of the database within the app installation. |
| Database User Ids | A JSON object representing the list or structure of database user IDs to assign. This should be valid JSON specifying the users to be set for the database. |
Output
The node outputs JSON data reflecting the response from the mittwald mStudio API after setting the database users. This typically includes confirmation of the updated user assignments or any relevant status information returned by the API.
No binary data output is indicated.
Dependencies
- Requires an API key credential for authenticating with the mittwald mStudio API.
- The node uses the base URL
https://api.mittwald.defor API requests. - Proper configuration of the API authentication credential in n8n is necessary.
Troubleshooting
- Invalid JSON in Database User Ids: Since the
databaseUserIdsproperty expects JSON, providing malformed JSON will cause errors. Ensure the input is valid JSON. - Authentication Errors: If the API key credential is missing or invalid, the node will fail to authenticate. Verify that the API key is correctly configured.
- Resource or Operation Mismatch: Make sure the resource is set to "App" and operation to "App Set Database Users" to use this functionality.
- API Response Errors: If the API returns errors (e.g., invalid app installation ID or database ID), verify that these IDs are correct and exist in the mittwald system.
Links and References
- mittwald mStudio API Documentation (official API docs, if publicly available)
- n8n documentation on creating custom nodes