SQL User Permissions

hostmaster 4 years ago updated by Vlad R 4 years ago 1

Hey Vlad,

What are the minimum user permissions for Filerun on the SQL DB side? I started up a new install recently using Docker rather than bare metal and saw an error log for:

ERROR 1142 (42000) at line 3: CREATE command denied to user 'filerun'@'' for table 'df_file_logs'

I usually only give SELECT, INSERT, UPDATE, and DELETE permission, is anything besides CREATE required?

The installation process requires also CREATE and even ALTER, for setting up the database. You can remove these permissions once the installation is done.