Manage Data Security

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

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:

Element	Description
Source Instance	Select the Fusion source.
Secure by Object	Select the area in the data warehouse to which the user requires access.
Overwritable	There is no user assistance for this option.
User Filter	Type the first character of a user name to limit the list below to names beginning with that character.
Users	For each user that you want to provision, move the user name from the left hand list to the right hand list.

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:

Header	Header Name in CSV File	Valid Values
Action (Mandatory)	Action	Insert / i / + For Inserting, Delete / d / - For Deleting
Data Source (Mandatory)	DataSourceNumber, DATA_SOURCE_NUMBER, DSN, Source	Name or DSN ID given to a data source instance. Use ‘All’ to performs the action for all configured data sources that are defined for the given data security type. Note: Values are case in-sensitive.
User (Mandatory)	Username, USER_NAME, User, UserId	User name or user ID as available in Oracle Internet Directory (OID). Values are case-insensitive.
Data Security Type (Mandatory)	Code, DataSecurityCode, DATA_SECURITY_CODE	Data security code or name given to the data security type. Values are case-insensitive.
Data Security Value (Mandatory)	Value, DataSecurityValue, DATA_SECURTY_VALUE	A non empty data security value. Values are case-sensitive.
Overwrite (Optional)	Override, Overwrite	No / 0 / False / N To make non-over-writable else it is over-writable.