Skip to Content
Author's profile photo Former Member
Former Member
May 29, 2012 1 minute read

Expiring User Passwords with HANA and BI4 Feature Pack 3

By default when a HANA user is created, the password lifetime is set to 182 days (6 months).  This can be modified via the configuration options as seen below.

In HANA Studio go to

  • Administration
  • Configuration tab
  • Expand indexserver.ini
  • Expand password policy
  • Confirm the value for maximum_password_lifetime

5-29-2012 10-04-58 AM.png

In the event that a user’s password does expire, how does a user using one of the frontend BI4 tools know?  Find out below.

To show what happens when a user’s password has expired,  we force the user to change their password with the following SQL statement

 ALTER USER <MYUSER> FORCE PASSWORD CHANGE

Client Tools

HANA Studio

/wp-content/uploads/2012/05/1_106348.png

Explorer

/wp-content/uploads/2012/05/2_106352.png

Web Intelligence

  /wp-content/uploads/2012/05/3_106353.png

Crystal Reports for Enterprise

/wp-content/uploads/2012/05/4_106354.png

Crystal Reports 2011

/wp-content/uploads/2012/05/5_106355.png

Dashboards (Xcelsius)

/wp-content/uploads/2012/05/6_106344.png

Analysis Edition for OLAP

/wp-content/uploads/2012/05/7_106358.png

Analysis Edition for Microsoft

/wp-content/uploads/2012/05/8_106357.png 

The client tools show a different error message depending on which one is used.  Only the Analysis Edition for Microsoft, lets a user change thier password within the tool itself.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Vishal,

      great blog.

      Thank you.

      Andy.

      Author's profile photo Ethan Jewett
      Ethan Jewett

      Thanks for the blog. Question for the security folks: Shouldn't Analysis Edition for Microsoft be prompting for the old password before allowing someone to change the password? With the current setup, I could hijack someone's account by sitting down at their computer at exactly the right time (if they have Analysis Edition for MS open already).

      Cheers,

      Ethan