USP_SECURITY_SYSTEMPRIVILEGE_UPDATEASSIGNMENT

Saves a privilege assignment for a system role.

Parameters

Parameter	Parameter Type	Mode
@SYSTEMROLEID	uniqueidentifier	IN
@SYSTEMPRIVILEGECATALOGID	uniqueidentifier	IN
@GRANTORDENY	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_SECURITY_SYSTEMPRIVILEGE_UPDATEASSIGNMENT(@SYSTEMROLEID uniqueidentifier,
    @SYSTEMPRIVILEGECATALOGID uniqueidentifier,
    @GRANTORDENY bit,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    if exists(select ID from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = @SYSTEMPRIVILEGECATALOGID)
    begin
        update dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE set GRANTORDENY = @GRANTORDENY,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate() 
        where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = @SYSTEMPRIVILEGECATALOGID;
    end
    else
    begin
        insert into dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE (SYSTEMROLEID,
            SYSTEMPRIVILEGECATALOGID,
            GRANTORDENY,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@SYSTEMROLEID,
            @SYSTEMPRIVILEGECATALOGID,
            @GRANTORDENY,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;