Is it dangerous for the longterm stability of the Craft database to modify user privileges (i.e. suspend users or change user group) at a database level?

Example scenario:

Somebody has gone into the database and suspended specific users and didn't use the Craft CP. Would doing this action in Craft CP modify more tables than just "craft_users"?


Manually modifying anything in the database inherently comes with risks. The biggest is that you risk corrupting data by getting it in an inconsistent state across tables, which can cause foreign key constraint violation errors later on.

In the case of suspending/un-suspending a user, that risk is pretty low since it's limited to just the craft_users table, but in the case of changing user groups, it's higher because now you're talking about craft_users, craft_usergroups, craft_usergroups_users.

In both cases, you also need to take into account any plugins that might be using that data as well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.