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.
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. |