How to reset drm admin password??

                                            How to reset drm admin password??

Login as the drm schema/database user

Step 1 Make back up of current table data:

for oracle database execute the following:

         create table rm_user_bak as
         select * from rm_user;


for sql server execute the following:
Make sure that the drm database is being used 
         USE { database }
         SELECT * INTO dbo.rm_user_bak
         FROM dbo.rm_user;

---------------------------------------------------------------------------------

Step 2: Rest password to default::

for oracle execute the following:

update rm_user
set c_password ='S5ZY+Gwo/mR0xJVvh/bgB4e+eioS3lG7JVoO2PtuemrNAXcXc3qivFQAA62kKbUuZF8VceuEiUxgq8pznMUrTg=='

where c_user_name ='ADMIN';
Commit;

for sql server execute:

update dbo.rm_user
set c_password ='S5ZY+Gwo/mR0xJVvh/bgB4e+eioS3lG7JVoO2PtuemrNAXcXc3qivFQAA62kKbUuZF8VceuEiUxgq8pznMUrTg=='
where c_user_name ='ADMIN'

Commit

Step 3: test the changes
 The password has been reset to the default.
 Try logging into the application using user ADMIN and the password Welcome!


Warning: Do NOT update any other user with this password it will NOT work.

if there are any issues restore the the original password from the created back up table