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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: