User Management in Teradata
The Teradata Database Administrators are responsible to manage the users in Database.They will create the Teradata account for each user with limited space and access on the database objects.
Password expiration interval in Teradata
In order to maintain the active users in the Database, Teradata DBA will set the password expiration interval like 90 days/120 days in the DBC tables. So after the expiration interval,User will receive an email alert from Teradata DBA to make the password change to retain access in the Teradata.
If user didn’t change the password, it will be expired in the system. Then the Teradata will throw the following error message “3032 User password has expired” when user try to access the database.
Change Teradata password using SQL Assistant
There are two ways to change the password if it is not yet expired:
User can run the below modify command in the Teradata SQL Assistant to reset the password.
Modify user <user_name> as password = "<new_password";
- <user_name> – Mention your Teradata user name
- <new_password> – Give your new password to access the Teradata
Example : Change the TestUser password
2. Change password option in Teradata SQL Assistant
In SQL assistant application, User can navigate following option to change password
Teradata SQL Assistant → Tools → Change Password.
Once click the Change password, it will give popup box to reset the password. User need to give both Current and New password in this box. Then just click the OK button to reset the new password in Teradata