Stored procedure

[Divya_Bharathi]

is it possible to use stored procedure for MODIFY USER by passing the username and password in the procedure call.

[Raja_KT]

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 ? :)

[Divya_Bharathi]

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...

[Raja_KT]

You can see here:

http://www.info.teradata.com/edownload.cfm?itemid=113480020

[Divya_Bharathi]

Thank u so much