The password for my user id is L4sQ&dS8.
I did the following :
Ran a bteq as .logon prod/subrata_das_admin,L4sQ&dS8; ---> This worked fine
when ran a MLOAD as below it failed with error --> 13:55:53 UTY1008 RDBMS failure: 8017, The UserId, Password or Account is invalid.
I have encountered this recently. Not sure about one slingshot answer, but, try doing the following:-
1. Enclose the password in double-quotes. It worked in Arcmain, not in BTEQ.
2. for special characters @ and /, use \ as escape character. It worked in BTEQ, not in ARCMAIN.
3. Check what special characters are allowed in the "Special" section in Teradata Admin tool .
TDAdmin, Tools->Administer-> Profiles ->"Password" tab. Do not tweak with it until you get an approval from your team.
If anybody finds any other alternatives, please post them.