All Forums Database
SriniD 25 posts Joined 02/14
28 Mar 2014
Finding User information

Hi,
Can some one help me to find list of users and their passwords, ie., in which DD table/view we can find all users and corresponding passwords?
Thanks in advance,
Srinivas.

Raja_KT 1246 posts Joined 07/09
28 Mar 2014

I am afraid if passwords can be obtained :). Did you select from  dbc.dbase?

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

SriniD 25 posts Joined 02/14
28 Mar 2014

Yeah :), actually I'm looking for userid with initial passwd and I'm using query:
select PasswordChgDate from dbc.Dbase where databasename = 'xxxx';
and the result is showing as -735,531, how to convert this in to date format?
 
Thank you,
srinivas.

Kishore_1 208 posts Joined 03/10
30 Mar 2014

Teradata uses one way encrytion for storing user passwords,we cannot decrypt the password if its forgotten.
Only way is to reset the password with the help of administartor.
 

Kishore_1 208 posts Joined 03/10
31 Mar 2014

You may use PasswordModTime in DBC.DBASE to get the last modification time stamp.
PasswordChgDate  value is stored as a Julien date in DBC.DBASE.Conversion of Julien date to integer date format is available in the definition of DBC.users dictionary view.However it is populated as null in DBC.users  in cases where the PasswordChgDate <0 in DBC.dbase.

SriniD 25 posts Joined 02/14
08 Apr 2014

Thanks for your reply Kishore. In the above case the PasswordChgDate value from DBC.Dbase is < 0 and as you said that DBC.Users view is populates null if PasswordChgDate is <0, then how would I convert that Julien date into normal date format. Please suggest.
 
Thanks,
Srini.

Adeel Chaudhry 773 posts Joined 04/08
09 Apr 2014

http://forums.teradata.com/forum/tools/how-to-convert-ordinal-julian-date-to-calendar-date

-- If you are stuck at something .... consider it an opportunity to think anew.

Adeel Chaudhry 773 posts Joined 04/08
09 Apr 2014

If you can share more about what you are trying to achieve, we may be able to help you in a better way.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.