topic Re: change Teradata Password directly from SAS in SAS Programming

change Teradata Password directly from SAS

reginado — Tue, 20 Jun 2017 13:49:17 GMT

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!

Re: change Teradata Password directly from SAS

RW9 — Tue, 20 Jun 2017 13:53:19 GMT

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.

Re: change Teradata Password directly from SAS

reginado — Tue, 20 Jun 2017 13:59:16 GMT

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

Re: change Teradata Password directly from SAS

RW9 — Tue, 20 Jun 2017 14:02:55 GMT

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.

Re: change Teradata Password directly from SAS

Tom — Tue, 20 Jun 2017 14:44:04 GMT

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;

Re: change Teradata Password directly from SAS

Kurt_Bremser — Wed, 21 Jun 2017 06:02:39 GMT

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.