How to enable new table creation for the patch for our API (FIDO)server

You may get an error message when using the API server with the latest patch.

Use this SQL query to add needed permissions to allow the initial startup of the API server to create needed DB tables:

EXEC sp_addrolemember 'db_ddladmin', '{databaseUsername}'

In the above, put in the actual username that is being used to connect to the DB in the "{databaseUsername} section.

To remove the role assignment after the initial startup, use:

EXEC sp_droprolemember 'db_ddladmin', '{databaseUsername}'