SAP HANA: Reset Password for RESTRICTED USER Using Self Service

[andrew_wu]

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

[eason_chen]

Hi,

You could use following SQL to unselect the option “Disable JDBC/ODBC access”
ALTER USER <your db user> ENABLE CLIENT CONNECT