Database password reset from SAS

[RupaJ]

Hello,

Is there a way to reset the database password from SAS? I would like to give the ability for SAS users to be able to reset their database password (in my case Teradata pw) from SAS. Is there a way to do it?

I was wondering if I could run a macro (that is on Teradata) from SAS that would reset the password for the user. Is that possible?

Thanks

[Krueger]

SQL Pass Through and you can use (EDIT): since your using TeraData it looks like you would use MODIFY USER to change passwords. Not very secure and is going to require an existing connection to the database, although I'm pretty sure your going to need a connection to the database regardless of method.

[ChrisNZ · Accepted solution]

I'd expect the syntax to be similar to Oracle's:

proc sql;                          
  connect to oracle (user="&username" path='xx' pw="&cur_pwd" ); 
  execute (alter user &username identified by "&new_pwd" replace "&cur_pwd" ) by oracle; 
quit;

[RupaJ]

Thank you @ChrisNZ  and @Krueger  for the response. I was reading further on how to connect to Teradata and here is how we do it.

proc sql; 
connect to teradata (user="john" server="abc" pw="test123" mode="teradata" ); 
execute (modify user john as password="test234" ) by teradata; 
quit;