USP_WEALTHPOINTCREDENTIALS

Gets WealthPoint search credentials for the current user.

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@USERNAME	nvarchar(100)	INOUT
@PASSWORD	nvarchar(100)	INOUT
@SITEID	nvarchar(20)	INOUT

Definition

Copy



            CREATE procedure dbo.USP_WEALTHPOINTCREDENTIALS (
                @CURRENTAPPUSERID uniqueidentifier = null,
                @USERNAME nvarchar(100) = null output,
                @PASSWORD nvarchar(100) = null output,
                @SITEID nvarchar(20) = null output
            ) as begin
                set nocount on;

                exec dbo.USP_GET_KEY_ACCESS;

                if exists(select 1 from dbo.WEALTHPOINTCREDENTIALS where ID=@CURRENTAPPUSERID)
                    select
                        @USERNAME = USERNAME,
                        @PASSWORD = convert(nvarchar(100), DecryptByKey(PASSWORD))
                    from
                        dbo.WEALTHPOINTCREDENTIALS
                    where
                        ID = @CURRENTAPPUSERID;

                close symmetric key sym_BBInfinity;

                select 
                    @SITEID = CLARIFYSITEID
                from
                    dbo.INSTALLATIONINFO

                return 0;
            end;