Security Question about TM1
-
- Posts: 2
- Joined: Tue Feb 15, 2011 4:41 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 9.5.1
Security Question about TM1
Is it possible to setup TM1 Security in such a way that a User is able to Create Cubes and Create Dimensions, but not able to create processes??
-
- 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 Question about TM1
Only by granting users read access to TI processes that do the job of the actual dimension and/or cube creation from parameterized inputs.
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Security Question about TM1
I havent tested this yet but what happens if you try to add ADMIN access to a dimension? It's not greyed out as an option when setting dimension security. This wouldn't allow you to create one from scratch Im assuming but would it allow an end user to add and modify elements without using a TI?
-
- 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 Question about TM1
Your original post said "CREATE" so the answer is no, you can't do that unless either 1) you are a member of the group ADMIN or 2) someone who is an ADMIN has created a TI process that does the heavy lifting of the cube and/or dimension creation process and then given you at least READ access to it. Granting ADMIN access to a dimension will let you modify it or delete it, but not create any new ones. I'm not sure what granting ADMIN access to a cube will do since you can't change a cube, only delete and re-create, which this would not give you.
-
- 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 Question about TM1
Actually I am pretty sure that ADMIN level security rights to a dimension or cube for a group (where members are not also members of the ADMIN group) will NOT give users permission to delete the object. What admin access will do in the case of a dimension is to create, delete, modify and publish public subsets. The same goes for admin level access to a cube except with views not subsets. In quite limited circumstances this can be quite useful functionality. You often hear people say (including consultants) that only global admins have the ability to create and modify public subsets and views but this is not true strictly speaking. The other ability that members of a group with admin access to a cube or dimension have is the ability to apply or release a lock or hold on the object.tomok wrote:Granting ADMIN access to a dimension will let you modify it or delete it, but not create any new ones. I'm not sure what granting ADMIN access to a cube will do since you can't change a cube, only delete and re-create, which this would not give you.
-
- Posts: 2
- Joined: Tue Feb 15, 2011 4:41 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 9.5.1
Re: Security Question about TM1
I did not get answer i am seeking
If i have give a user Admin Access, than yes users will be able to create cubes, dimensions and processes
However my goal is to allow a user to create Cubes, Dimensions but disallow them to Create Processes and Chores
Is it possible?
If i have give a user Admin Access, than yes users will be able to create cubes, dimensions and processes
However my goal is to allow a user to create Cubes, Dimensions but disallow them to Create Processes and Chores
Is it possible?
-
- Site Admin
- Posts: 6667
- 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: Security Question about TM1
I'm sorry, could you clarify which part of Tomok's answer:dwsupport wrote:I did not get answer i am seeking
If i have give a user Admin Access, than yes users will be able to create cubes, dimensions and processes
However my goal is to allow a user to create Cubes, Dimensions but disallow them to Create Processes and Chores
Is it possible?
(my emphasis) didn't give you the answer you are seeking? It may not have been the answer that you wanted to hear, but life's like that sometimes.Tomok wrote: you can't do that unless either 1) you are a member of the group ADMIN or 2) someone who is an ADMIN has created a TI process that does the heavy lifting of the cube and/or dimension creation process and then given you at least READ access to it.
The process concerned will obviously need to have parameters which allow the user to specify what to create.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.