How to change admin password in Hyperion Shared services

                                 Admin password change in Hyperion Shared services


Situation and Goal:
we have installed and configured Hyperion worksapce, shared services and other components in cloud servers. Then we have started migration from client LCM dump, first we did HSS migration. In this case, the admin password (which has given at the time of configuration time) is overwritten.

So, we need to reset password to some known with encrypted with in the CSS users table.

Steps:
1. 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.

2. Run the below command:

update CSS_USERS
set PASSWORD= '{SSH2}mpQoG4jU00otFocLZM6CWWUzpk9ZmSY5In3l3ZzFCH5byRhkG6ow7z4KxXmXWXSo'
where name='admin';

This will setup the admin users password to ‘password'

OR

Run the below command:

update CSS_USERS
set PASSWORD= ‘{SSH2}FvSZVSvSmzvjT/02Nn1TrJyQk8SqNus4Fw4m2cNxa3zkSLe8HFiJy7cT8zUDGiWi’
where name='admin';

Commit the changes

Note: Take backup of CCS_USERS table before do any changes.

Reference:
http://epmcult.blogspot.in/2014/06/resetting-hyperion-workspace-admin.html

Thanks,
Mady