Non-Admin User SecurityRefresh

Post Reply
ryanr
Posts: 7
Joined: Fri Dec 30, 2011 4:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: Excel 2010

Non-Admin User SecurityRefresh

Post by ryanr »

I have security set by rules in parts of my TM1 application, and need a secuity refresh for users to be able to view new items I give them access to.

I recently created a utility to allow them to create custom store sets, but they can't view them until a security refresh is performed, which they still have to ask me to do. Is there a way to get them to trigger something that runs that security refresh without me giving them security admin rights? I'm thinking I'm going to have to write something custom with the API, but I thought I would ask before I go down that rabbit hole.


Thanks in advance
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: Non-Admin User SecurityRefresh

Post by Alan Kirk »

ryanr wrote:I have security set by rules in parts of my TM1 application, and need a secuity refresh for users to be able to view new items I give them access to.

I recently created a utility to allow them to create custom store sets, but they can't view them until a security refresh is performed, which they still have to ask me to do. Is there a way to get them to trigger something that runs that security refresh without me giving them security admin rights? I'm thinking I'm going to have to write something custom with the API, but I thought I would ask before I go down that rabbit hole.
Or. more simply, give them an action button which runs a TI that executes the SecurityRefresh command. The TI runs with Admin rights, even if the user who triggered it doesn't have them.
"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.
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Non-Admin User SecurityRefresh

Post by declanr »

Just in addition to Alan's reply, you will need to right-click on the TI process and select "security access" in addition to giving the users access to run it. As of version 9.4 (or maybe 9.5?) processes run by a non-admin user will run with "data admin" access, so if you want it to be able to change security you need to enable that option for the process.
Declan Rodger
ryanr
Posts: 7
Joined: Fri Dec 30, 2011 4:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: Excel 2010

Re: Non-Admin User SecurityRefresh

Post by ryanr »

I was aware of the SecurityRefresh command, but did not realize I could have a non-admin user run a process with that command in it! Thank you both!
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Non-Admin User SecurityRefresh

Post by mvaspal »

also be aware of this, so test whether it works
http://www-01.ibm.com/support/docview.w ... wg1PM83539
Post Reply