In a tutorial video the SAP HANA Academy’s Jamie Wiseman shows how to create a user using the “NO_FORCE_FIRST_PASSWORD_CHANGE” option. This option enables a user to not have to change their password the very first time they log into SAP HANA. Note that your password’s lifetime policy will still apply. The option is new in SAP HANA SPS11 but will not work in prior iterations of SAP HANA.


Check out Jamie’s video below.

Screen Shot 2015-12-11 at 11.54.52 AM.png

Lines 2-3 of the syntax shown below creates a user with the NO FORCE_FIRST_PASSWORD_CHANGE option. With this option the user’s current and valid password is specified during the user creation. Therefore it is highly recommended to use a secure password at this point. The user you’re logged into SAP HANA as must have the appropriate rights to create a user.

Screen Shot 2015-12-11 at 11.56.27 AM.png

After all of the syntax is run navigate to the results from the SELECT * FROM USERS statement.

Screen Shot 2015-12-11 at 12.17.25 PM.png

The newly created user’s information is displayed on the last line of the table. Scrolling to the two Password columns (PASSWORD_CHANGE_TIME and PASSWORD_CHANGE_NEEDED) verifies that the user will not need to change their password until the password’s lifetime expires.

Screen Shot 2015-12-11 at 12.18.23 PM.png

If you’re unsure regarding the system view name that contains your password policy it will be displayed in the results table from the SELECT * FROM M_PASSWORD_POLICY statement. Note that the password’s lifetime policy in Jamie’s demonstration in 182 days.

Screen Shot 2015-12-11 at 12.30.15 PM.png

For more tutorials videos on What’s New with SAP HANA SPS11 please check out this playlist.


SAP HANA Academy – Over 1,300 free tutorials videos on SAP HANA, SAP Analytics and the SAP HANA Cloud Platform.


Follow us on Twitter @saphanaacademy and connect with us on LinkedIn to keep apprised of our latest free tutorials.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply