If you are a universe designer, you will need to specify access levels for groups and users for your universe.
To manage user and group access to your universe do as follow:
- Tools à Manage Security à Manage Access restrictions
- The window divided into 2 pans
- The left pan displays available restrictions
- The right ban display users and group.
- The left pan displays available restrictions
Restrictions:
- Object level: you can restrict user or group from access a specific object.
- Row level: you can restrict user or group from access specific rows from specific table based on criteria.
- Table mapping: display data from another table for user or group.
- General restriction: connection, control, SQL
Example:
We want to create the following restrictions:
- Restrict user / group from accessing profit object. (object level)
- Restrict user / group to display VIP customer's data based on VIP flag column. (row level)
- Display data for retail users / groups from retail data table instead of displaying it from the corporate table. (table mapping)
- Limit number of rows retrieved by user query (general)
To preview user and group access to your universe do as follow:
- Tools à Manage Security àpreview net access restrictions.
- Select user or group that you want to preview access for.
- Click preview.
Notes:
- You can create mixed restriction that mix many types of restrictions (object, row, table mapping and general)
- If you apply the same restriction to more that one group then you can specify priority for them.
How does it work if you need to send out one report (say via email) to different people with various security access? Will each person only see the detail that is relevant for their security level?
ReplyDeleteOr do you need to run the report a number of times to cater for each security setting?