Resetting Hyperion Admin Password if you forgot

Author: - Sanjay Purohit

Audience:  Hyperion Solution Architects and Hyperion Database Administrator.

I received a phone call from one of my coworker regarding resetting Hyperion admin password.  He installed Hyperion on a server.  He also prepared an installation document and handover to client for review.  The client was kind enough and did not user Hyperion for a while and also lost installation document.  After few months- my friend received a phone call from client asking Hyperion admin password and he also forgot. He needed to reset the Hyperion admin password. This posting is dedicated to my friend JP.  

objective

The goal of this posting is to “Reset Hyperion Work-space admin Password”.  Hyperion encrypts user friendly language and stores the password on shared services schema. All the native users can be seen on “CSS_USERS” table.  Resetting the admin password is an easy task and can be achieved little knowledge of relation database. 

Login to Shared Services Schema ( The user you used during the shares services configuration) with SQL developer or any other tools and look for “CSS_USERS” table.

 Run the following command

update CSS_USERS

set PASSWORD= '{SSH2}mpQoG4jU00otFocLZM6CWWUzpk9ZmSY5In3l3ZzFCH5byRhkG6ow7z4KxXmXWXSo'

where name='admin';

This will setup the admin users password to ‘password'

Note:-

To set the password to ‘welcome1’ =

‘{SSH2}FvSZVSvSmzvjT/02Nn1TrJyQk8SqNus4Fw4m2cNxa3zkSLe8HFiJy7cT8zUDGiWi’

To set the password to ‘password’ =

'{SSH2}mpQoG4jU00otFocLZM6CWWUzpk9ZmSY5In3l3ZzFCH5byRhkG6ow7z4KxXmXWXSo'