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
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;
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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.