How do I handle SQL permission errors?

How do I handle SQL permission errors?

AuthorFullName__c
JFrog Support
articleNumber
000001404
ft:sourceType
Salesforce
FirstPublishedDate
2016-10-06T13:35:44Z
lastModifiedDate
2024-03-10T07:47:59Z
VersionNumber
4

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 which 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.