USP_FENXTKEYSANDLOCKSTATUS

Parameters

Parameter	Parameter Type	Mode
@ENVIRONMENTID	nvarchar(50)	IN
@ACCESSTOKEN	nvarchar(2000)	INOUT
@REFRESHTOKEN	nvarchar(50)	INOUT
@EXPIRESON	datetime	INOUT
@LOCKEDON	datetime	INOUT

Definition

Copy



            create procedure dbo.USP_FENXTKEYSANDLOCKSTATUS
            (
                @ENVIRONMENTID nvarchar(50),
                @ACCESSTOKEN nvarchar(2000) OUTPUT,
                @REFRESHTOKEN nvarchar(50) OUTPUT,
                @EXPIRESON datetime OUTPUT,
                @LOCKEDON datetime OUTPUT
            )
            as
            begin

                exec dbo.USP_GET_KEY_ACCESS;

                select 
                    @ACCESSTOKEN = coalesce(convert(nvarchar(2048), DecryptByKey(ACCESSTOKEN)),''), 
                    @REFRESHTOKEN = coalesce(convert(nvarchar(256), DecryptByKey(REFRESHTOKEN)),''), 
                    @EXPIRESON = EXPIRESON, 
                    @LOCKEDON = LOCKEDON
                from dbo.FENXTTOKEN with (REPEATABLEREAD, XLOCK) --hold an exclusive lock on the row in FENXTTOKEN.  Doesn't do anything unless the proc is run in a transaction.

                where ENVIRONMENTID = @ENVIRONMENTID;

                close symmetric key sym_BBInfinity;
            end