Oracle XE user for TIBCO Admin Domain repository

If you elect to use TIBCO EMS as the transport of the administration domain, you need to use database as the domain repository. If you plan to use Oracle XE Universal as the database, you might be looking for the reference on what privilege to grant to the user of the schema for the TIBCO Administrator Domain. The following information might help.

Assuming the user you want to create is called "tibpg", run the following sql commands to create the user and grant the privileges. You should be able to specify and use this user in the DomainUtility to create your domain without problem.

GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO tibpg IDENTIFIED BY tibpg

ALTER USER tibpg DEFAULT TABLESPACE USERS;

ALTER USER tibpg TEMPORARY TABLESPACE TEMP;

Cheers