NEW USER ID Creation through database

[abdeshpa]

Hi,

I am using v8.5.0.6. I have a dev environment which is not being used since a long time.
And now when I want to use it and trying to log in with the known id and password, it says incorrect credentials.
Is there a way, I can retrieve the password of the ID I was using to login or is there a way I can create a new user running any ars* command?

I tired querying the arsuser table but found that the passwords are encrypted. What is the encryption type that is used by OnDemand for mp - AIX,DB2?
I also tried updating the arstash command, but not sure whether that feature is supported on v8.5.

Thanks
AD

[Alessandro Perucchi]

Hello abdeshpa,

As any secure system to store password, you cannot decrypt the passwords, since they are using hashing technique.
The only way to find your password is to search all possible by brute force.

And Stash is something else. Is to help automate batches. But the password that you put in the stash file must match the one in the database!

-
Alessandro

[Justin Derrick]

You'll need to reset the password for the account you want to use in the Admin client.  If you don't have access to the admin account (because you don't have that password either) then you'll need to reset it by blanking out the password for the admin account in the arsuser database table.

[Alessandro Perucchi]

Hello Justin,

:-) true, I just didn't want to give that solution in public  ;D

[Justin Derrick]

:-) true, I just didn't want to give that solution in public  ;D

Yeah, that's why I didn't include the SQL to do it.  Although, I wonder if posting the SQL that's done right is less dangerous than having people discover it on their own.  :D

-JD.