Changing Your Teradata Password

Nice simple one today.

The first thing you should ever do when granted access to any system, is change your password! Afterall, your IT policy probably a) requires you to and b) will hold you accountable for any misuse under your ID!

This is simple in Teradata – you log in using your existing password, and submit the following query;

MODIFY USER YouUserName AS PASSWORD=YourNewPassword;

Submit the query, and you’re done.

If you’re in SQL Assistant, you can also use ToolsàChange Password – but I find the above quicker.