How do I handle SQL permission errors?

When facing the following exception:


‘Caused by: org.apache.derby.iapi.error.StandardException: An SQL data change is not permitted for a read-only connection, user or database.’

This error can be related to permissions on the bundled Derby DB


Please make sure that the user who is running Artifactory has sufficient permissions (full read, write and execute) on the $ARTIFACTORY_HOME/data/derby directory.


If this is not the issue, please raise a ticket with JFrog Support, and attach the ${artifactory_home}/etc/storage.properties file and the full stacktrace of the error.