USP_MAPPING_GETCREDENTIALS

Gets mapping credentials for the system.

Parameters

Parameter	Parameter Type	Mode
@USERNAME	nvarchar(100)	INOUT
@PASSWORD	nvarchar(100)	INOUT
@KEY	nvarchar(64)	INOUT

Definition

Copy



            CREATE procedure dbo.USP_MAPPING_GETCREDENTIALS (
                @USERNAME nvarchar(100) = null output,
                @PASSWORD nvarchar(100) = null output,
                @KEY nvarchar(64) = null output
            ) as begin

                exec dbo.USP_GET_KEY_ACCESS;

                if exists(select 1 from dbo.MAPPINGCREDENTIALS)
                    select
                        @USERNAME = USERNAME,
                        @PASSWORD = convert(nvarchar(100), DecryptByKey(PASSWORD)),
                        @KEY = convert(nvarchar(100), DecryptByKey([KEY]))
                    from
                        dbo.MAPPINGCREDENTIALS;

                close symmetric key sym_BBInfinity;

                return 0;
            end;