change Teradata Password directly from SAS

[reginado]

Hi, would you know if there is possibility to change teradata user password directly through SAS?

Does the pass-trough statement will work?

Thanks a lot!

RD

[RW9]

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.

[reginado]

Let assume this is allowed, is this possible? Would you know for sure?

[RW9]

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.  

[Kurt_Bremser]

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.

[Tom]

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;