06-20-2017 09:53 AM
Wouldn't have thought so, isn't that a breach of system integrity being able to just change administrative features externally to the application. Even considering such a thing I would first speak with your ITas you may breach their policies by doing it outside the app in question.
06-20-2017 10:02 AM
I have not seen anything like this. The SAS passthrough system is SQL passthrough, i.e. SQL statements get passed to the database SQL parser. Theoretically if you can alter things via the SQL tables using SQL you could, however would result in some interesting explanations of where the production database has gone.
Also, if you had some sort of command line interface to the database, then you could push command line instructions out, requires you to have comand line access, the database to have a command line admin tool.
06-21-2017 02:02 AM
Once again, Maxim 6 comes into play. A google search for "teradata change password syntax" reveals that @Tom's code suggestion is actually correct for Teradata. But you will need a Teradata user with the necessary permissions for this.
06-20-2017 10:44 AM
I think that the Teradata syntax for changing a password looks like this:
MODIFY USER "username" AS PASSWORD ="*******"
So you can use PROC SQL to push that statement into Teradata.
proc sq ; connect to teradata ... ; EXECUTE ( MODIFY USER "username" AS PASSWORD ="*******" ) BY TERADATA; quit;