{"id":1304,"date":"2016-11-27T15:16:36","date_gmt":"2016-11-27T15:16:36","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1304"},"modified":"2016-11-27T15:16:36","modified_gmt":"2016-11-27T15:16:36","slug":"changing-a-password-in-teradata","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=1304","title":{"rendered":"Changing a Password in Teradata"},"content":{"rendered":"

There are a couple ways to change a user’s password in Teradata.\u00a0 Two methods covered here are using a SQL statement in Teradata’s SQL Assistant, and the other is using the Teradata Administrator.\u00a0 The examples shown are being performed on Teradata Express VM.<\/p>\n

SQL statement in Teradata’s SQL Assistant<\/h3>\n

In the example below, a user is changing its own user account’s password.\u00a0 This can be done with out administrative privileges.\u00a0 To change another account’s password would require to be logged on as an administrator.\u00a0 This SQL can be run from other tools like BTEQ & Teradata Studio.<\/p>\n

Regarding the password and special characters, the following was taken from Teradata’s Administrative Guide: “Special characters are only underscore (_), dollar sign ($), or pound sign (#), unless the password is enclosed in double quotes, in which case other special characters can be used.”<\/em><\/p>\n

First is a query that the user can see its own information:<\/p>\n

select UserName, CommentString from dbc.users;<\/pre>\n
\"teradata_password_change01\"<\/a><\/p>\n
The SQL Statement for changing the password:<\/p>\n
modify user < user > as password = \" <new password> \";<\/pre>\n
\"teradata_password_change02\"<\/a><\/p>\n
After the statement is executed, the password will change to a string of “*” in the query window.\u00a0 In the status bar at the bottom of the SQL Assistant will show if the statement was successful or if there was an error.<\/p>\n
\"teradata_password_change03\"<\/a><\/p>\n
Teradata Administrator<\/h3>\n
In the Teradata Administrator (need to be an logged on as an administrator), click on the user needing the password change.\u00a0 Then click the Tools drop down menu.\u00a0 Click on the Modify User option.<\/p>\n
\"teradata_password_change04\"<\/a><\/p>\n
A pop-up app will appear.\u00a0 Enter the new password in the Password text box.\u00a0 Then click on the Modify button, then click on the Close button.<\/p>\n
\"teradata_password_change05\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
There are a couple ways to change a user’s password in Teradata.\u00a0 Two methods covered here are using a SQL statement in Teradata’s SQL Assistant, and the other is using … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":1309,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[90,89,66],"class_list":["post-1304","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teradata","tag-change","tag-password","tag-teradata"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1304"}],"collection":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1304"}],"version-history":[{"count":7,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1304\/revisions"}],"predecessor-version":[{"id":1316,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1304\/revisions\/1316"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1309"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1304"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}