Change Password

Database
Enthusiast

Change Password

Hi,

how can I change the password of a Teradata login ?

Regards
4 REPLIES
Enthusiast

Re: Change Password


MODIFY USER Myuserid AS PASSWORD = mypass;

Re: Change Password

i used "DBC" to do that, but failed, it says "3524: The user does not have DROP USER access to database xyz. "

i couldn't understand why system needs to drop user access since it's just password change

Re: Change Password

You can use the Teradata Administrator to change your password. Go to
-->Tool
--> Modify User

and change your password over there
Enthusiast

Re: Change Password

From Data definitions statements manual.

To execute the MODIFY USER statement

IF you are … | THEN you must have the DROP USER privilege on …
-----------------------------------------------------------------------------------------
not the user being modified | the referenced user.
|

You should be able to do a GRANT DROP USER on userid TO DBC; from DBC and then execute the MODIFY USER statement.