USP_APPUSER_ADD

Adds a new application user to the database

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@USERSID	varbinary	IN
@DISPLAYNAME	nvarchar(255)	IN
@ISSYSADMIN	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_APPUSER_ADD
    (
    @ID uniqueidentifier = null output,
    @USERSID varbinary(85),
    @DISPLAYNAME nvarchar(255),
    @ISSYSADMIN bit = 0,
    @CHANGEAGENTID uniqueidentifier = null
    )
as
begin
    set nocount on;

    declare @CURRENTDATE datetime

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

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

    set @CURRENTDATE = getdate()

    insert into dbo.APPUSER 
            (ID, USERSID, DISPLAYNAME, ISSYSADMIN, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED) 
        values
            (@ID, @USERSID,  @DISPLAYNAME, @ISSYSADMIN, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

    return 0    
end