Hello. Such behavior is specified in documentation: http://www.h2database.com/html/grammar.html#alter_user_rename
Now you can use a recover tool to export your database into plain SQL file: http://www.h2database.com/html/advanced.html#using_recover_tool After this you can create a new database with another user and execute this script with RUNSCRIPT FROM 'your_file.h2.sql' to import content of old database into new one. There is an another way with modifying the sources of the database. You can comment out this check in org.h2.engine.Engine.openSession(): if (user != null) { if (!user.validateUserPasswordHash(ci. getUserPasswordHash())) { user = null; } } Without this check you can connect using valid user name with any password. This can be used to execute ALTER USER SET PASSWORD 'new_password' After it you will be able to use unmodified database again. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
