I wanted to know if i can use any code to send an auto generated e-mail containing the password to the end user after his/her Teradata user is created?
Also i have a stored procedure which when called creates a user but ,the password is to be sent manually,can I make any modifications with that stored procedure or write another script for sending an auto generated e-mail with password in it. Please let me know if anybody has an idea about the same.
Thank you in advance.
I guess doing this via a script is the easiest way.
The Teradata Python module would be a good choise for this. It allows you easy SQL generation, SQL execution and further processing (like sending the email).
I wrote a short demo for this. You can find it at https://github.com/d2k/TDPythonCreateUser.git
The create user parameter will be specified in an ini file.
The password is created and after the user is created send via email to the user. Not even the DBA will see the password as long as the script is not changed (by sending also blind copies) and the log level is not changed...
Will it be possible for you to share the SP which you have for user creation? I am too working on a similar code and your SP can guide me on that.