Skip to Content
0
Mar 08, 2017 at 10:04 AM

How to setup a productive password for a HANA user using SQL?

1819 Views

Hi Guys,

I need to know if it's possible to change the initial password in HANA to Productive password using SQL command?

To give you a better understanding below is the scenario:

* End user use HANA credentials to login into LUMIRA. If somehow user locked themselves out or we create a new user then below are the steps we need to follow:

1. We reset the password for user in HANA through GUI or using SQL

2. We then login with user's initial password in HANA and then change the initial password to Productive password.

3. We share the productive password with End user

4 . User use Productive password of HANA to login into LUMIRA.

Now if we had a request to reset password for 100 users then it would be very difficult to and time consuming to login 100 times with each user and then setup a productive password for every single user.

Do we have any option or SQL command through which we can change the initial password to Productive and avoid step 2 mentioned above.

Note:

I have tried below command but it's not working due to syntex error.

ALTER USER <user_name> {<password val_option> }

ALTER USER <USERNAME> PASSWORD <PASSWORD> [NO FORCE_FIRST_PASSWORD_CHANGE];

I know that if we change the parameter FORCE_FIRST_PASSWORD_CHANGE = FALSE then system won't ask to change the password but this is the last resort and I don't want to go for that unless there is no other option.

We are on HANA 1.0 SPS 9.

Any help will be much appreciated.

Regards,

Anuj