USP_BBNCUSERMAP_GETBBNCUSERCREDENTIALS

Returns the Blackbaud Internet Solutions user name mapped to the application user id, as well as the password for that user, if Blackbaud Internet Solutions resides in the same database.

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN
@DATABASESINTEGRATED	bit	IN

Definition

Copy



CREATE procedure dbo.[USP_BBNCUSERMAP_GETBBNCUSERCREDENTIALS]
(
  @APPUSERID uniqueidentifier,
  @DATABASESINTEGRATED bit
)
as 
  set nocount on;

    declare @USERNAME nvarchar(50);
    declare @CREDENTIAL64 nvarchar(1024);

  if @DATABASESINTEGRATED = 1
    select 
      @USERNAME = [ClientUsers].[UserName],
      @CREDENTIAL64 = [ClientUsers].[Password] 
    from dbo.[BBNCUSERMAP]
    inner join dbo.[ClientUsers] on [ClientUsers].[UserName] = [BBNCUSERMAP].[BBNCUSERNAME]
    where [BBNCUSERMAP].[ID] = @APPUSERID;
  else
    begin
        select @USERNAME = [BBNCUSERNAME] from dbo.[BBNCUSERMAP] where [ID] = @APPUSERID;
      set @CREDENTIAL64 = '';
    end

  select
    @USERNAME as [USERNAME],
    @CREDENTIAL64 as [CREDENTIAL64];

  return 0;