Security Groups for dimension restrictions

Tips and tricks
1

Hi all,

I may not be reading the help docs correctly, but I cannot see how we would assign security to a group of users.

Situation
We have a large number of sales personnel which will be accessing the sales database. We want to reduce the number of rows being shown to a regional variant. I.e. North Europe, South europe.

We have this as a dimension and will want to assign by group rather than individual, this situation is going to become more problematic when financial statements will be used in the main stream as we will want to secure the P&L/BS to specific regional areas for the staff, I.e. Germany company only sees the Germany P&L etc.

Requirement
We need to be able to assign users to groups then the groups control access to the databases. The administration overhead would be large and cumbersome. There is a danger that users would see more that they should with the user by user assignment.

Please let me know if there is an easier means of securing data as I can only see folders which is not the same as a security group.

Thanks,

Jon.

1 Like
2

Hi Jon,

There are 2 pages within the documentation that should prove useful, have you seen both of these?

https://help.phocassoftware.com/display/userdoc/User+restrictions

This gives an overview of how to restrict user access.

https://help.phocassoftware.com/display/userdoc/Database+restrictions

The second link however goes into more detail around how users can inherit restrictions based on their group/territory setting against each user rather than having to ‘hard code’ the reference for every user. Does this help at all?

The 2nd link sounds closer to what you are trying to achieve in using groups, but if you have any other questions then please let me know.

Regards,

Lee Konrath

1 Like
3

Hi @anon41607707,

Thank you! the second link was what I was missing.

@IT_Support, since this is no longer a production suggestion, would you mind moving this post to the general hints & tips section as to not dilute this posting group.

Kind regards,

Jon

4

Got it @JonKemp - thank you!