Use this dialog to provide users with security access to specifc areas of the data warehouse, for example by Department Name, Legislative Group Name, or Payroll Name. For example, you might want user Ashah to have access to data relating to payroll. You can create users one at a time or upload multiple users from a comma separated value (CSV) file. If you need to update a user’s details, then you must delete the user’s details, then re-create the user.
User Data Security Objects tab
Element | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Search | Specify values in one or more drop down lists, then click Search. Click Reset to clear the search fields and start a new search. | ||||||||||||
User Data Security Objects |
A list of existing security user to object mappings. For example, if you assign user AShah to HR — Department List’ with the values ‘01 Landing’, and ‘01 Service’, then the list will display one row for HR — Department List\01 Landing and one row for HR — Department List\‘01 Service. |
||||||||||||
Add |
Display the New Security Definition dialog, which enables you to create a new user account. Use the New Security Definition as follows:
|
||||||||||||
Remove | Delete the currently selected user account. | ||||||||||||
Mass Delete Security Definitions | Delete multiple user accounts for a specific functional area. For example, you might want to delete all user accounts for HR — Payroll List. Click this icon to display the Mass Delete Security Definitions dialog, specify the functional area for which you want to delete user accounts by selecting a value from the Secure by Object drop down list, then click Delete. |
Data Security Import tab
Element | Description | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
List of imports |
The details and status of each CSV file that has been imported. |
|||||||||||||||||||||
Bulk Upload |
Use this option to display the Bulk Upload dialog, which enables you to specify the name and location of a CSV file containing multiple sets of user account details. The CSV file must be formatted as follows: The first line of the CSV file should be a header row, followed by one or more data rows. The Header can be in any order, but data row values must be placed adjacent to the headers. Header names are read case-insensitive i.e. ACTION, Action or action are interpreted as Action header. The following table describes the required columns in the CSV file:
|