TM1 access when group assignment is overlaped

Post Reply
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

TM1 access when group assignment is overlaped

Post by hyunjia »

HI gurus ,

Could anyone clarify the scenario when a user is assigned to multiple groups ?

I alwasys assume TM1 would use the access from the group with the highest security cleareance if a user has been assigned to more than 2 groups . But it seems I am wrong .

I have the scenario where a user is assigned to both a "WRITE" group and a "READ" group ,the user would only have read access . If I assign the user to "WRITE" group only , he would have write access to the data .

much appreciate your replies .

Cheers
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: TM1 access when group assignment is overlaped

Post by Alan Kirk »

hyunjia wrote:
Could anyone clarify the scenario when a user is assigned to multiple groups ?

I alwasys assume TM1 would use the access from the group with the highest security cleareance if a user has been assigned to more than 2 groups . But it seems I am wrong .

I have the scenario where a user is assigned to both a "WRITE" group and a "READ" group ,the user would only have read access . If I assign the user to "WRITE" group only , he would have write access to the data .
The least restrictive access applies when you're applying security from different groups to the same object. (A specific cube, dimension, element, etc.) If any group gives you write access to that object, you have write access to it regardless of whether other groups give you a lesser access.

The most restrictive access applies when you're looking vertically down the object hierarchy. (In other words, if you have only read access to a cube then it doesn't matter whether another group gives you write access to the elements; you cannot write to that cube, period.)

See this thread for a more wide-ranging discussion.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Re: TM1 access when group assignment is overlaped

Post by hyunjia »

Thanks Alan , the post is very helpful .
Post Reply