Hi I was working from the SQL Grammar definition on ALTER USER SET PASSWORD:
http://www.h2database.com/html/grammar.html#alter_user_set_password > Admin rights are required to execute this command If all I need to do is supply the current user, then I will give that a go at some point. Thanks forgetting back on this. paul. On Tuesday, 4 February 2014 15:43:53 UTC, Steve McLeod wrote: > > On checking the code, it seems that it already allows a user to change > their own password, if they are not the admin user. > > Can you post the SQL commands you used when it didn't work? > > > On Tuesday, 4 February 2014 12:38:16 UTC-3, Steve McLeod wrote: >> >> >> We could make it like Oracle: If and only if the username specified is >> the current logged-in user, then admin rights are not needed. >> >> ALTER USER *currentlyLoggedInUser* SET PASSWORD 'hello123' >> >> I'd like to see if I can fix this. >> >> >> On Monday, 3 February 2014 11:36:43 UTC-3, Paul Eden wrote: >>> >>> Hi >>> >>> Are there any pans to allow this? It seems a little extreme that a User >>> has to have admin in order to change their own password? >>> >>> thanks >>> >>> paul >>> >> -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
