is it possible to use stored procedure for MODIFY USER by passing the username and password in the procedure call.
You can use DDL,DCL in stored proc. Are you not breaching security when you pass password as parm? :). You can refer to the stored proc material. Why dont you try ? :)
As am new to teradata....am unaware of all tis.....can you plz let me know where can i access the stored proc material which you mentioned...