Database Privileges Needed for Manual Schema Creation

Lists the privileges needed specific to database type for manual schema creation.

Privileges Granted Based on the Database Type
Database Type Privileges
Oracle Required : You must not have the DBA privilege, and you must be assigned to the database schema.

Permissions: Grant the following permissions:

grant create session

Microsoft SQL Server
Required: Set 'read_committed_snapshot' to ON by executing:
  1. alter database <amx-database> set read_committed_snapshot on
  2. Use the case insensitive collation setting for <amx-database>
  3. Assign <amx-user> the default database <amx-database>

Permissions: grant db_datareader, db_datawriter to <amx-user> for the <amx-database>.

IBM DB2

Required: Configure the database with a 32KB page size (instead of the default 4KB page size).

Permissions: Create dmluser with connect database permission.

To run the DDL Script Generator utility, see DDLGeneratorTask.

What to do next

After installation, use TIBCO Configuration Tool to configure the third-party JDBC driver for your database.