maya.public

Parameters

Name	Type	Mode
_idclient	integer	IN
_email	character varying	IN
_password	character varying	IN

Definition

/*
v20150409 RRB
Create a generic user for customer integration purposes 
*/
DECLARE
_idrole integer;
_idmayauser integer;
BEGIN
SELECT idrole INTO _idrole FROM ot_rw_createrole_viewuser(_idclient) idrole;
SELECT idmayauser INTO _idmayauser FROM mayauser WHERE idclient = _idclient AND username = 'integracion';
IF NOT FOUND THEN
INSERT INTO preference(idpreference,createbyuser,creationdate,lastmodifiedbyuser,lastmodificationdate,originatingsystem)
VALUES(nextval('sec_preference'),0,now(),0,now(),'DBA');
INSERT INTO mayauser(idmayauser,idrole,idclient,idpreference,username,name,lastname,email,phone,password,omnitracuser,createbyuser,creationdate,
lastmodifiedbyuser,lastmodificationdate,originatingsystem,enabled,logintries,status,passchanged)
VALUES(nextval('sec_mayauser'),_idrole,_idclient,currval('sec_preference'),'integracion','integracion','integracion',_email,'',md5(_password),false,0,now(),0,now(),'DBA',true,0,1,false);
END IF;
RETURN coalesce(_idmayauser,currval('sec_mayauser'));
END

ot_rw_createuser_integracion(integer, character varying, character varying)

Parameters

Definition