I may not be reading the help docs correctly, but I cannot see how we would assign security to a group of users.
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.
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.