dbTalk Databases Forums  

SSAS 2005 - Read Metadata Permissions on a Cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SSAS 2005 - Read Metadata Permissions on a Cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dejan Sarka
 
Posts: n/a

Default SSAS 2005 - Read Metadata Permissions on a Cube - 03-08-2006 , 01:33 AM






In BOL, topic "Granting Read Metadata Permissions"
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uas9/html/c857e48e-64b0-4ffe-900d-a0a3ddafcefb.htm),
we can read:

------
Granting Read Metadata Permissions on a Cube Giving a database role
permission to read the metadata of a cube gives the role permission to read
the definition of a cube. Experienced analysts and developers may need to
view the definition of objects in the cube in the course of their work.
However, for security reasons, the definition of cube objects should not be
visible to most business users. The existence of this permission enables
administrators to grant certain users the permission to view object
definitions in a particular cube without also granting them the permission
to modify these objects or view objects in other cubes.
To give a database role permission to read the metadata of a cube
In SQL Server Management Studio, connect to the instance of Analysis
Services, , expand Roles for the appropriate database in Object Explorer,
and then click a database role (or create a new database role).
Click Cube Access in the Select a Page pane, locate the cube in the Cube
list, and then select the Read Definition check box for that cube.
------

I can't see the Read Definition check box. Also, there is only "Cube"
option, not "Cube Access". Am I missing something, are BOL wrong, or is it a
bug in SSMS?

Thanks,

--
Dejan Sarka




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.