Resetting DBA password

Posted by Admin on 01-Jul-2009 03:27

Hi,

My new employer has a old progress 7.3 database that was running on Novell 5.0.

The firm that made the system for him is no longer in business, and apparently, nobody has the DBA password.

I connected without a password, but I am only able to access the schema info, not the data.

Would you please help me finding a way to reset\recover the DBA password?. Your help is highly appreciated.

Thanks

All Replies

Posted by Admin on 04-Dec-2009 15:10

I am having the same problem. Did anyoine figure out the solution?

Posted by Admin on 05-Dec-2009 02:28

First, take a look to the application starting scripts or shortcuts,

check if you can find ... the -U (user) -P (password) startup parameters.

If you are connected, take a Procedure Editor (prowin32, mpro) and try this:

DEFINE VARIABLE cNewPassword AS CHARACTER NO-UNDO.
DEFINE TEMP-TABLE tempUser NO-UNDO LIKE _User.
FIND FIRST _User WHERE _User._UserId = "userid" EXCLUSIVE-LOCK NO-ERROR.
IF AVAILABLE (_User) THEN DO:
BUFFER-COPY _User EXCEPT _User._Password TO tempUser ASSIGN
tempUser._Password = encode("jill").
DELETE _User.
CREATE _User.
BUFFER-COPY tempUser TO _User.
END.
ELSE
MESSAGE "This Userid does not exist"
VIEW-AS ALERT-BOX INFO BUTTONS OK.

This thread is closed