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
