Creating a New Data Platform Database

You can create a new database during the install.

SQL Server

If you choose the Create new Data Platform database automatically option during installation, the SQL login user account that you specify must have the privileges described in this section.

When using SQL authentication for creating the BDNA/Publish database, the SQL user must be granted the following SQL Server roles:

• dbcreator
• securityadmin
• public

When using Windows authentication (SQL Server only) for creating the BDNA/Publish database, the Windows user must be granted the following SQL Server roles:

• dbcreator
• public

Oracle

If you choose the Create new Data Platform database automatically option during installation, the Oracle login user account that you specify must have the privileges described in this section.

Ideally, DBA privileges are required to create a new user. In lieu of DBA privileges, the user you are connecting AS, should have the following minimum roles/privileges, using the ADMIN OPTION.

• SELECT_CATALOG_ROLE
• RESOURCE
• CONNECT
• EXECUTE_CATALOG_ROLE
• GATHER_SYSTEM_STATISTICS
• SELECT ANY DICTIONARY
• CREATE TABLESPACE
• DROP TABLESPACE
• CREATE VIEW
• QUERY REWRITE
• CREATE DATABASE LINK
• ALTER SESSION
• CREATE ANY TABLE
• CREATE USER
• DROP USER
• EXECUTE PRIVILEGE (for sys.dbms_obfuscation_toolkit.md5 function)