Authorities
and privilegesUse the Define Warehouse Group notebook to define warehouse groups that can access Data Warehouse Center objects. By defining warehouse groups, you can restrict warehouse access to Data Warehouse Center sources, targets, and processes.
Warehouse groups provide individual warehouse users with varied levels of access to Data Warehouse Center functions. When you define a warehouse user, you assign the user to specific warehouse groups that you define in this notebook. You can also add warehouse users to a warehouse group with this notebook.
To define a warehouse group:
In the Name field, type a name for the new warehouse group. The name can be up to 80 characters including spaces.
Optional: In the Administrator field, type the name of the administrator for this warehouse group.
Optional: In the Description field, type a short description of the new warehouse group.
Optional: In the Notes field, type any additional information that an administrator might need to know about this warehouse group.
From the Available privileges list, select the privileges that you want to assign to the warehouse group and click >. The privileges that you select are moved to the Selected privileges list.
If you want to assign all of the privileges in the Available privileges list, click >>.
On the Warehouse Users page, select the warehouse users that you want to include in the warehouse group from the Available users list, and click >. The warehouse users that you select are moved to the Selected users list.
If you want to include all existing warehouse users from the Available privileges list, click >>.
On the Warehouse Sources and Targets page, select the warehouse sources and warehouse targets to which the warehouse group will have access from the Available warehouse source and targets list and click >. The warehouse sources and targets you've selected are moved to the Selected warehouse source and targets list.
If you want the warehouse group to have access to all warehouse sources and targets in the Available warehouse source and targets list, click >>.
On the Processes page, select the processes to which the warehouse group will have access from the Available processes list and click >. The processes you have selected are moved to the Selected processes list.
If you want the warehouse group to have access to all processes in the Available processes list, click >>.
Click OK to save your changes and close the notebook.
Related information
Changing a warehouse group definition
Removing a warehouse group definition