dbTalk Databases Forums  

Re: Read / Write permission on a cube

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


Discuss Re: Read / Write permission on a cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vinay Dharmik
 
Posts: n/a

Default Re: Read / Write permission on a cube - 08-13-2004 , 04:26 AM






"Philippe" <Philippe (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,

The following code doesn't work (permission Read/write):
permissiontoset="
MEMBERSECURITY
PERMISSION Access="Read" AllowedSet="{Descendants([Fiscal Year].&[4])}"
UpperLevel="[Fiscal Year].&[4].Level"/
PERMISSION Access="Write" AllowedSet="{Descendants([Fiscal Year].&[4])}"
UpperLevel="[Fiscal Year].&[4].Level"/
/MEMBERSECURITY
dsorole.SetPermissions DimensionToSet, permissiontoset

While the following works (only read):
MEMBERSECURITY
PERMISSION Access="Read" AllowedSet="{Descendants([Fiscal Year].&[4])}"
UpperLevel="[Fiscal Year].&[4].Level"/
/MEMBERSECURITY
dsorole.SetPermissions DimensionToSet, permissiontoset

Can anybody helps me ?

Thanks for your help.

Philippe
Hi Philippe,
Use this (Read/write -- for write clause)

<MEMBERSECURITY >
<PERMISSION Access="Read" AllowedSet="{Descendants([Fiscal
Year].&[4])}"
UpperLevel="[Fiscal Year].&[4].Level"/>
<PERMISSION Access="Read/Write" AllowedSet="{Descendants([Fiscal
Year].&[4])}"
UpperLevel="[Fiscal Year].&[4].Level"/>
</MEMBERSECURITY>

Read: Determines which members are allowed to view. This permission
affects the size of the visible cube because it limits the members
that are displayed.
Read/write: Determines which members are allowed to be updatable. You
can define and grant this permission only if the dimension has been
write-enabled. If you grant this permission and the dimension is later
write-disabled, this permission is disabled, and end users cannot
update the dimension's members.

Vinay Dharmik


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.