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:
- alter database <amx-database> set read_committed_snapshot on
- Use the case insensitive collation setting for
<amx-database>
- 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.
|
PostgreSQL (Starting with TIBCO ActiveMatrix Hotfix 002)
|
- Create the database user using pgAdmin or SQL Shell and grant required privilege.
- Create the database. The user created in the step 1 must be the owner of the database.
- In pgAdmin or SQL shell, run the following queries for the database created in the step 2 :
CREATE FUNCTION pg_catalog.text(bigint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int8out($1));';
CREATE CAST (bigint AS text) WITH FUNCTION pg_catalog.text(bigint) AS IMPLICIT;
CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));';
CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT;
CREATE FUNCTION pg_catalog.text(smallint) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int2out($1));';
CREATE CAST (smallint AS text) WITH FUNCTION pg_catalog.text(smallint) AS IMPLICIT;
|
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.
Copyright © TIBCO Software Inc. All rights reserved.