This content has been marked as final. Show 5 replies
The error message that you are getting is due to using a user that does not have administrator rights (that's OTM admin right not DB admin rights) or entering the wrong password.
Unfortunately there is no way to reset a password, you can run the following SQL againts the OTM db to get a list of admin users:
select * from "OTM"."Users" where ISADMIN = 1 and deleted = 0;
Note that you may need to change OTM for the user that owns the OTM tablespace, default is OTM.
If you know the password for one of them try using that username/password combination other ways you are gonna have to look for a user that you know the password, to do so run the following query:
select * from "OTM"."Users" where ISADMIN = 0 and deleted = 0;
That will give you a list of none admin users, then find a user that you know the password off and update the ISADMIN to equal 1 you can use the following SQL query:
update "OTM"."Users" set isadmin = 1 where userid = +<the_user_id>+;
Change the <the_user_id> for the actual user_id.
Then you should be able to login using that user.
Hope this helps
Thnx alex, it was successfully done!!
but found 1 strange issue:
we've run the query as per your instructions. while working on that, we found that "Administrator" user had already that OTM admin rights but it was not working, don't 9 the reason . besides that, there was one another "Default" user mentioned in the list. we'd set the rights for that and logged into the admin app. there it worked and also asked for the upgrade version. we also verified that all earlier data is now available.
but issues comes when i logged in *2nd time* in the admin app, there i was not able to connect with both the users "Administrator" & "Default" users
Fortunately, while setting the OTM admin rights, i applied on 1 another user name also and currently only that user is working. could you tell me the reason of that why i am not able to connect with that users?