Database user requires additional permissions

Steps to reproduce

Steps to reproduce:
1. Install Opencast 4.x (develop currently)
2. Attempt to schedule an event

Actual Results:
Big stack traces:
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opencast.TL_mh_assets_properties' doesn't exist
Error Code: 1146
Call: INSERT INTO TL_mh_assets_properties (id) SELECT FROM mh_assets_properties t0 WHERE ((t0.namespace = ?) AND t0.mediapackage_id IN (SELECT DISTINCT t1.mediapackage_id FROM mh_assets_snapshot t2, mh_ass
ets_properties t1 WHERE ((t1.mediapackage_id = t2.mediapackage_id) AND ((t2.organization_id = ?) AND (t1.mediapackage_id = ?)))))
bind => [3 parameters bound]
Query: DeleteAllQuery(referenceClass=PropertyDto sql="DELETE FROM TL_mh_assets_properties")

Expected Results:
A scheduled event

Workaround (if any):

Fixed and reviewed


Greg Logan


Greg Logan


Incorrect Documentation