For Oracle setup, on the Database tab, you must complete these fields:
Service (Oracle service for connecting to the Oracle database)
Database Name (name of the database that will be created)
User name (database user name)
Password (database password)
If Use Windows Integrated Security is selected, when FDM is accessed from the Web, the FDM application server account is used to log on to the Oracle Server database. When FDM is accessed from Workbench, the account used to log on to Workbench is used to log on to the Oracle Server database.
If Use Windows Integrated Security is not selected, you must enter a valid Oracle account. When you create an FDM database, the account used to log on to the Oracle database must either be granted the DBA role or have the following system privileges: Create Procedure, Create Sequence, Create Session, Create Table, Create Trigger, Create View, and Query Rewrite.