Article - CS318959
Permissions to grant to the PostgreSQL database user for Persistence Providers and Database Things in ThingWorx Platform
Modified: 26-Feb-2025
Applies To
- ThingWorx Platform 8.1 to 9.7
- PostgreSQL
Description
- What PostgreSQL permissions must be granted to twadmin
- Permissions needed for the ThingWorx Database User
- What Postgres permissions should be given to the ThingWorx Database User
- Permissions granted by the thingworxPostgresDBSetup install script
- Configuring a Database Thing and need to confirm what permissions the user should be granted
- Created a Secondary Persistence Provider and need to know what PostgreSQL permissions the database user requires
- Unable to perform purge operations via a Database Thing or a Persistence Provider
- Cannot start ThingWorx Platform with postgresql log in <PostgreSQL Home>\data\pg_log showing
- <Date Time> [20173-1] <ThingWorx Database User>@<ThingWorx Database> ERROR: permission denied for relation <Database Table>
This is a printer-friendly version of Article 318959 and may be out of date. For the latest version click CS318959