USP_OLAPDATASOURCES_GETSOURCENAMES_FORUSER

CREATE procedure dbo.USP_OLAPDATASOURCES_GETSOURCENAMES_FORUSER 

@CURRENTAPPUSERID uniqueidentifier

/*
Returns list of OLAP DATA sources that the current user has permission for
*/

/*
pdg 9.4.2008 
This now returns all OLAP data sources since we rely on native Analysis Services security to determine cube permissions.
*/


as

if @CURRENTAPPUSERID is null
begin
    raiserror('@CURRENTAPPUSERID is required for dbo.USP_OLAPDATASOURCES_GETSOURCENAMES_FORUSER',16,10);
    return 11;

end


--pdg 11.7.2008 check to make sure the olap package was loaded.

IF OBJECT_ID(N'dbo.OLAPDATASOURCE', N'U') IS  NULL
  return 0;


SELECT 
  SOURCENAME 
FROM 
  dbo.OLAPDATASOURCE AS ODS
WHERE 
  ODS.ISOLAP=1
ORDER BY 
  SOURCENAME;


return 0;