I am creating a database authentication system. Unfortunately, I am not able to create a stored procedure to create a new user. I’ve worked with MSSQL quite in depth before, however I am at a loss as to how to solve this problem. Below is the code I am using to create the stored procedure: [quote]DELIMITER $$
create PROCEDURE USP_CREATE_LOS_ALTOS_USER (USER_NAME1 VARCHAR(100),PWD1 VARCHAR(100),ROLE_NUM1 TINYINT)
BEGIN INSERT INTO LOS_ALTOS.USERS (USER_NAME, PWD, ROLE_NUM) SELECT USER_NAME1, PWD1, ROLE_NUM1 END $$
Does anybody see anything blatantly wrong? I’ve been working at it for a few hours, and I’m still up against a brick wall.