USP_SIMPLEDATALIST_OLAPDATASOURCES_FORUSER
Returns the list of OLAP data sources the current user has permissions to query
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_OLAPDATASOURCES_FORUSER
@CURRENTAPPUSERID uniqueidentifier
as
/*
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.
*/
SELECT
ID AS VALUE,
SOURCENAME AS LABEL
FROM
dbo.OLAPDATASOURCE WHERE ISOLAP=1
ORDER BY
SOURCENAME;