Skip to Content
avatar image
Former Member

Cannot change password policy

I have a running HXE using the docker image from SAP. When I use Hana Studio to edit the password_layout it saves, but as soon it saves it is reset to default. I have tried editing directly in the file and using the following statement:

"alter system alter configuration ('indexserver.ini', 'SYSTEM') set ('password policy', 'password layout') = 'A' with reconfigure;"

The ini file is updated but it does not reflect when I try to create a new user. I have stopped and started the service using "HDB stop" and "HDB start".

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 12, 2018 at 05:10 AM

    let us create a user , say USER1 and when this user log on for first time , it will ask you to change the password which refers to default value 'true' in force_first_parameter_change

    if this parameter changed to false then when the user log on the first time , it will not prompt to change the password .

    NOTE: administrator can chage the password at any time with SQL command ALTER USER user_name FORCE PASSWORD CHANGE.

    Add comment
    10|10000 characters needed characters exceeded