USP_DATAFORMTEMPLATE_ADD_APPUSERPROXYUSER

            CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_APPUSERPROXYUSER
            (
                @ID uniqueidentifier = null output,
                @APPUSERID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @PROXYUSERNAME nvarchar(255) = '',
                @DISPLAYNAME nvarchar(255) = '',
                @ISPROXYUSER bit = true,
                @INVALIDLOGINATTEMPTS int = 0
            )
            as

            set nocount on;

            if @ID is null
                set @ID = newid();

            if @CHANGEAGENTID is null
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            declare @CURRENTDATE datetime = getdate();

            begin try

                --Proxy user will be a non-admin on Add

                insert into dbo.APPUSER
                    (ID, USERSID, CUSTOM_AUTHENTICATION_USERID, DISPLAYNAME, ISSYSADMIN, CONSTITUENTID, ISPROXYUSER, INVALIDLOGINATTEMPTS, PROXYOWNERID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values
                    (@ID, SUSER_SID('NT AUTHORITY\ANONYMOUS LOGON'), @PROXYUSERNAME, @PROXYUSERNAME, 0, NULL, @ISPROXYUSER, @INVALIDLOGINATTEMPTS, @APPUSERID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

                --Copy roles/permissions from PROXYOWNER

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_APPLICATIONUSERCOPYROLES @ID, @APPUSERID, @CHANGEAGENTID;
            end try

            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

                return 0;