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