We understand that some customers have security policies which compel them to use the Liferay platform to connect to the database as a user that does not have elevated privileges; privileges to change the structure of the tables, such as CREATE, ALTER and/or DROP.
Sometimes a plugin or hotfix that we provide may require a database update to resolve the issue. Unlike a full Liferay Portal upgrade, there isn't an obvious expectation that there will be a database update. So if you apply the new plugin/hotfix that requires a database update, you will receive database permission errors, for example:
Due to the complexity of database structure and possible data changes, our patching processes do not allow us to provide the raw SQL scripts with the fixes.
Find a maintenance window to:
- Set the application server (Ex. Tomcat) to connect to the database as a privileged user with CREATE/ALTER/DROP rights.
- Start up the Liferay platform and let the update commence.
- Switch back to the secured user.