DATA Step, Macro, Functions and more

change Teradata Password directly from SAS

Reply
Occasional Contributor
Posts: 8

change Teradata Password directly from SAS

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

Super User
Super User
Posts: 7,401

Re: change Teradata Password directly from SAS

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.

Occasional Contributor
Posts: 8

Re: change Teradata Password directly from SAS

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

Super User
Super User
Posts: 7,401

Re: change Teradata Password directly from SAS

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.  

Super User
Posts: 6,939

Re: change Teradata Password directly from SAS

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Super User
Posts: 6,500

Re: change Teradata Password directly from SAS

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;

 

Ask a Question
Discussion stats
  • 5 replies
  • 104 views
  • 0 likes
  • 4 in conversation