DSO and Cell Security

DSO and Cell Security

Post by Lars Rasmusse » Thu, 08 Nov 2001 06:30:22



Hi All,

Does anybody know if it is possible to change the cell security policy in a
cube role using DSO?

Cheers,

Lars

 
 
 

DSO and Cell Security

Post by Walter Biff » Thu, 08 Nov 2001 23:44:47


Hi Lars,

This sample comes from the BO, 'Working with Roles'

.....
  ' Create a new cube role named TestRole, based on the database role
   ' named TestRole.
   Set dsoRole = dsoCube.Roles.AddNew("TestRole", sbclsRegular)

   ' Change the role properties for the cube role.
   With dsoRole
      ' All of the other properties are propagated from the
      ' TestRole database role.

      ' Prevent the users associated with this role from
      ' reading the [Store Cost] measure.
      .SetPermissions "CubeRead", _
         "Measures.CurrentMember.Name <> ""[Store Cost]"""
   End With

The code example demonstrates the use of Multidimensional Expressions (MDX)
syntax to set cell security with the SetPermissions method of the Role
object.

hth

-walter biffi


Quote:> Hi All,

> Does anybody know if it is possible to change the cell security policy in
a
> cube role using DSO?

> Cheers,

> Lars


 
 
 

1. Cell security using DSO

Anyone who knows how to set the description field, using DSO, for a
certain MDX-expression regarding the cell security in Analysis
Services 2000???
I want to have an automatic update function therefore it is not
possible to do this manually.

2. MCI Chooses Informix (fwd)

3. Setting Analysis Services Cell Security Policy via DSO

4. Problem with Transaction

5. Calculated Cells and DSO

6. access command suppress in AP/PRO

7. Calculated cells/members in DSO?

8. optimizing type of querys

9. Security and DSO

10. Changing cube security using DSO

11. DSO and security

12. security with dso object over olap server

13. Changing cube security using DSO