All About Teradata Users and passwords

Password Maintenance Commands:


A) To unlock a user

MODIFY USER User1 As RELEASE PASSWORD LOCK;

B) Changing password of a user by a DBA or by user itself:

MODIFY USER Jack1 as Password=Jack1;

c) Assigning a temporary password for a user and prompting the user to enter a new password when logging first time with the password

MODIFY USER Rimmy2 as password=rimmy213 FOR USER;


The password settings of users of Teradata Database system are set in the table in DBC.SyssecDefaults with a single row.

ExpirePassword - After how many days passwords expire
PasswordMinChar - Minimum number of characters that passwords should have
PasswordMaxChar - Maximum number of characters that passwords should have
Password Digits - Are digits allowed in the passwords?
PasswordSpecChar - Are special characters allowed in passwords?
MaxLogonAttempts - Maximum number of times a user is allowed to enter wrong passwords before getting locked
LockedUserExpire - After how many days the locked user will expire
PasswordReuse - After how many days an old password can be reused.