USP_OLAPDATASOURCE_GETCONNECTIONINFO_FORUSER

CREATE procedure dbo.USP_OLAPDATASOURCE_GETCONNECTIONINFO_FORUSER

@CURRENTAPPUSERID uniqueidentifier,

@SOURCENAME nvarchar(255)


/*
Returns info needed to connect for pivot tables
SPWrap generated in SPWrapOLAP has been depreciated. Any changes should be updated in Blackbaud.AppFx.SpWrap
*/

as 

set nocount on;

declare @full bit;

select @full=dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);

if @full=0

    select TOP 1 @full=1 from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE AS SRSP

    inner join dbo.SYSTEMROLEAPPUSER AS SRAU ON SRSP.SYSTEMROLEID=SRAU.SYSTEMROLEID
    WHERE SRAU.APPUSERID=@CURRENTAPPUSERID AND SRSP.SYSTEMPRIVILEGECATALOGID='ED0420CE-CACC-4676-A78A-4F26519409EB' --Unrestricted OLAP read-access

    ;


declare @datasourceid uniqueidentifier;
select @datasourceid = ID from dbo.OLAPDATASOURCE

WHERE SOURCENAME=@SOURCENAME;

SELECT @full as HAS_FULL_ACCESS,@datasourceid AS DATASOURCEID;