USP_APPUSER_SETSYSADMIN

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SYSADMIN	bit	IN

Definition

Copy



CREATE procedure dbo.USP_APPUSER_SETSYSADMIN
(
    @ID uniqueidentifier, 
    @CHANGEAGENTID uniqueidentifier, 
    @SYSADMIN bit
)
as

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

begin
    update dbo.APPUSER 
    set    ISSYSADMIN = @SYSADMIN,
        HASRUNASRIGHTS = iif(@SYSADMIN = 1, 1, HASRUNASRIGHTS),
        DATECHANGED = GETDATE(),
        CHANGEDBYID = @changeAgentID 
    where ID = @ID;
end

return 0;