We are brand new to Teradata database and are using it as our database from SAS. We are wondering if anyone has a method to change Teradata passwords from SAS. We have put together a SAS stored procedure that we can utilitze to change Teradata passwords as long as they are not already expired. Once a password is expired or if it a new user with a pre-expired password, then our process breaks. We believe it is because Teradata is expecting something more than just the password in these cases. Does anyone know how to get around this?
What sort of failure do you see?
From the database side, when the password is expired logon succeeds but a MODIFY USER to change the passsword is the only acceptable statement.
So I would expect a 3032 warning (SYSDBRC), rather than the usual 0, on CONNECT.
Right now we are not exaclty sure what we are getting back from Teradata. We are in the process of adding detailed error collection to see what Teradata is telling us so we can make a better decision.