Hi All
We're trying to configure the 'Forget Password' via self-service, the emails sends out all good. But when trying to reset the password via http://<WebServerHost>/sap/hana/xs/selfService/user/setPassword.html?token=..., for HANA restricted users, we got error message "dberror(Connection.prepareStatement): 663 - user not allowed to connect from client".
After some researching, we find out that Restricted Users are only able to connect to the database using HTTP/HTTPS. We tried to assign role RESTRICTED_USER_ODBC_ACCESS or RESTRICTED_USER_JDBC_ACCESS to the user, but still getting the same error. The only way works for us is to unselect the "Disable JDBC/ODBC access" checkbox via database cockpit.

Because we're creating users via SQL statement, what I'm wondering is, is there a way to enable ODBC/JDBC access using SQL statement?
Thanks in advance for any help & suggestions.
Andrew