USP_ADORGANIZATIONALUNIT_UPDATECREDENTIALS

Updates the credentials used to manage the Active Directory organizational unit

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@USERACCOUNTSID	varbinary	IN
@USERPWD	nvarchar(180)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_ADORGANIZATIONALUNIT_UPDATECREDENTIALS
(
    @ID uniqueidentifier,
    @USERACCOUNTSID varbinary(85),
    @USERPWD nvarchar(180),
    @CHANGEAGENTID uniqueidentifier = null
)
as

set nocount on;

declare @CURRENTDATE datetime


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

set @CURRENTDATE = getdate()

begin try
    -- Open the symmetric key for encryption

    exec dbo.USP_GET_KEY_ACCESS;

    update dbo.ADORGANIZATIONALUNIT set
        USERACCOUNTSID = @USERACCOUNTSID,
        USERPWD = EncryptByKey(Key_GUID('sym_BBInfinity'), @USERPWD),
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID

    close symmetric key sym_BBInfinity;
end try

begin catch
    exec dbo.USP_RAISE_ERROR

    -- Make sure we close the symmetric key

    close symmetric key sym_BBInfinity;

    return 1
end catch

return 0