Setting Up Data Security By Importing User Data In A Bulk Load
During the Setting Up Data Security step in an OTBI-Enterprise deployment, Implementors can optionally provision users by importing in bulk load a set of user to data mappings in a comma separated value (CSV) file.
Before you start, prepare a CSV containing the user to data mappings, in the following format:
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, that is, ACTION, Action or action are interpreted as Action header. The following table describes the required columns in the CSV file:
Header Name in CSV File
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.
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.
No / 0 / False / N.
In Configuration Manager, select the Manage Data Security link on the Tasks pane.