topic Re: Database password reset from SAS in SAS Programming

Database password reset from SAS

RupaJ — Wed, 23 Oct 2019 20:00:11 GMT

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

Re: Database password reset from SAS

Krueger — Wed, 23 Oct 2019 20:14:50 GMT

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.

Re: Database password reset from SAS

ChrisNZ — Thu, 24 Oct 2019 00:10:08 GMT

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;

Re: Database password reset from SAS

RupaJ — Tue, 29 Oct 2019 12:01:38 GMT

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;