Skip to Content
0
May 28, 2018 at 06:55 AM

SAP HANA: Reset Password for RESTRICTED USER Using Self Service

613 Views

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

Attachments

restricteduser.png (13.6 kB)