Stored procedure

Database
Enthusiast

Stored procedure

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

4 REPLIES
Enthusiast

Re: Stored procedure

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

Enthusiast

Re: Stored procedure

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

Enthusiast

Re: Stored procedure

Enthusiast

Re: Stored procedure

Thank u so much