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:
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
connectdatabase 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;
