All Forums Database
Divya Bharathi 8 posts Joined 09/14
30 Sep 2014
Stored procedure

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

Raja_KT 1246 posts Joined 07/09
30 Sep 2014

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Divya Bharathi 8 posts Joined 09/14
01 Oct 2014

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 1246 posts Joined 07/09
01 Oct 2014

You can see here:
http://www.info.teradata.com/edownload.cfm?itemid=113480020

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Divya Bharathi 8 posts Joined 09/14
02 Oct 2014

Thank u so much

You must sign in to leave a comment.