Database Privileges Needed for Manual Schema Creation
Lists the privileges needed specific to database type for manual schema creation.
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:
|
Microsoft SQL Server |
Required: Set
Permissions: grant
|
IBM DB2 |
Required: Configure the database with a 32KB page size (instead of the default 4KB page size). Permissions: Create
|
PostgreSQL (Starting with TIBCO ActiveMatrix Hotfix 002) |
|
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.