How to define User Hierarchies

Use the UI from an access manager account to easily define user hierarchies.

About this task

The Data Security User Hierarchy represents the parent-child relationships between users; allowing for the creation and enforcement of a data-level security by permitting the parent of a hierarchy to look at specified servers and databases, but not the children. Depending on the configuration, inheritance can also take place in that the parent inherits the data-level security of the child.

1. Login as accessmgr and click Data Security > User Hierarchy.
2. Select a user from the Users drop-down menu to display it in the Data Security User Hierarchy pane. This example uses john smith as a user.
   
3. To add a user to john smith's hierarchy, right-click on the user in the Data Security User Hierarchy pane, and select Add user from the drop-down menu.
   
4. After clicking Add user from the drop down list, the Add user dialog appears. Select one or more users that you would like to add to the user's hierarchy, and then click Add.
   
5. After adding the users to a hierarchy, the Data Security User Hierarchy panel will be refreshed; allowing the user to drill down and see the new hierarchy.
   
6. Repeat the steps until all required users are defined to the data security user hierarchy.