Security Default

Post Reply
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Security Default

Post by jim wood »

Chaps,

As most of you are aware that the default security setting in TM1 is Write. The model I'm working on needs to be read only unless otherwise defined. Do you know if there is a way to change the TM1 default security setting. I can't find anything in the list of CFG commands in the Ops guide,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Security Default

Post by tomok »

jim wood wrote:Chaps,

As most of you are aware that the default security setting in TM1 is Write. The model I'm working on needs to be read only unless otherwise defined. Do you know if there is a way to change the TM1 default security setting. I can't find anything in the list of CFG commands in the Ops guide,

Jim.
There is no way to change the default in TM1, at least that I know of, except to actually create security on the object, be it cube, dimension, or element, and then make everyone's rights READ. It's not as cumbersome as you might think if you do this. In all my models I always create a group called Everyone and I make all users a member of this group with a rule on the }ClientGroups cube. I then create a }CubeSecurity cube and grant READ, once again via ruile, to the group Everyone for all cubes that all users should see. If necessary, I do the same for }DimensionSecurity and also }ElementSecurity if called for. Then you can create other groups to give out the WRITE access when needed.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Security Default

Post by jim wood »

That's pretty much is as I understood things as well, but you don't get if you don't ask.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Security Default

Post by lotsaram »

The ReadOnlyUser field in the ClientProperties cube might be useful in this case. Regardless of group membership and security settings if this field has a value of 1 then the user won't be able to write (to any cubes).

I don't really know why but this feature seems to be very seldom used but for some models it is quite handy.
Post Reply