Database Privileges Needed for Automatic Schema Creation
Lists the privileges needed specific to database type for automatic 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 connect, resource to <amx-user>. |
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). |
PostgreSQL (Starting with TIBCO ActiveMatrix Hotfix 002) |
|
Postrequisite: After installation, you have to use TIBCO Configuration Tool to configure the third-party JDBC driver for your database.