Hi @majortim
Thank you for reaching out to us.
Could you please check with your hosting team to check if the website database has got the right permissions?
If you are unable to log in to the site due to the error, kindly follow the instructions here to temporarily disable all iTSec features, so you can log in: How Do I Disable All Features If I Can’t Access My Site?
Looking forward to your response.
Best regards,
Shalom
I have talked to the host team. It does not allow changed privileges of the created database users.
So I have no option to change the privileges of the database users.
The User must definitely have full access to the database, with all privileges.
I’ll suggest creating a new user with the necessary permissions to see if it helps to resolve the issue.
Please let me know how it goes.
Firstly, I can no longer get into the iThemes Security settings to change the database user. The plugin no longer works as described above.
Secondly, I doubt that a new database user should have more rights than the previous one. As I said, the host does not allow that.
The plugin worked fine for years. Now after a recent update, it doesn’t. Is it correct that iThemes Security now wants more database rights recently? What if I can’t grant those if the host refuses?
Is it true that the plugin wants more rights for database users lately? This has changed with one of the latest updates? There are no plans to change that?
Hi @majortim
Can I please ask if you perhaps changed the host? Because we’ve never gotten any report on this nor was able to reproduce this. The host is responsible for the permissions needed on the site.
Have you tried uninstalling the iThemes plugin, deleting any itsec_tables in the database, then reinstalling to see if this helps?
Looking forward to your response.
Best regards,
Shalom
No, the host has not changed. Neither have my settings.
The default database user with r/w rights on my host has the following privileges: SELECT, UPDATE, INSERT, DELETE.
There is another admin user with more privileges on the host side. This is actually only for administrative purposes and not for standard use.
I have changed the database user in the WordPress config file once to this admin user. After that the plugin could start again. The error message “ALTER command denied to user” was gone. After that I changed the user back to the standard user. The plugin still works after that.
