[SAP HANA Academy] SAP HANA SPS11 - SAP HANA Security - How to Create a User with"NO_FROCE_FIRST_PASSWORD"

[Former Member]

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.

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.

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

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.

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.

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.