All Forums Database
Amit 8 posts Joined 02/06
04 May 2006
How to find a lost password for a user

Hi,Can anyone let me know if there is any way we can retrieve the user's password from any system table in Teradata.If someone forgets his/her SYSDBS password then what is the way to retrieve that.Thanks!

TDUser-781 35 posts Joined 12/04
04 May 2006

Hi Amit,I don't think you can retireve a pwd once it has stored in the DD. If you look at dbc.DBase table you may understand the reason...If I were you I would chenge the user pwd connecting with an administrator user to the RDBMS.Hope this helps,Bye,TDUser

Amit 8 posts Joined 02/06
04 May 2006

Thanks,But what if you forgets your only Administrators password :-) I know in a work situation it will not happen as you will have more than one administrators. This question come up when I was doing something on my personal server & had a hardtime in recalling my password.Is there any way we can decrypt the password stored in this DBase table?Thanks!Amit

TDUser-781 35 posts Joined 12/04
04 May 2006

Well, if you were on your personal server.... what about applying the best "stop and restart solution"? That, in your case, would be uninstall and install the RDBMS again? :-) Joking aside, I don't think what you want to do is possible, but I've never really investigate on it...Good luck in your inquiry!TDUser

Jim Chapman 449 posts Joined 09/04
04 May 2006

By design, passwords are stored in DBC.DBase using a one-way encryption method. If you forget a password, consider it gone forever.

You must sign in to leave a comment.