I have a number of mySQL-based databases, and recently changed the security settings. For all databases there is a user with complete control (i.e. all roles assigned), as well as a few regular users (ROLE_USER). This has worked fine until today. Now suddenly it is no longer possible to add and change data and fields in just one of the databases (the other ones still work as before). When connecting, the choice of login mode (single user or multi user) does no longer come up. In addition, when logged in as the user with admin rights, the policy under the 'Configure security' cannot be edited (greyed out). I still can add new users though.
I upgraded the Java runtime environment to 1.6 (this was necessary for anothr program) and it is possible that the particular database was open under the time. Could this be the reason?