Referencing an External Schema

To reference an external schema in TIBCO Designer, the default schema must have the proper access privileges. These are set in a command line. In the following syntax, adb_schema refers to the default schema in create_user.sql.

For Oracle, log in as system and grant create any trigger and drop any trigger permissions to the default schema. For example:

grant create any trigger to adb_schema
grant drop any trigger to adb_schema

In addition, Oracle and Sybase users must have permission to SELECT from a source table in an external schema. If table relationships are used, SELECT permission is required for both parent and child tables. SELECT, INSERT, UPDATE, and DELETE permissions are required for accessing a destination table in an external schema.

For Sybase, execute the following command before creating catalog tables for the external schema:

sp_role "grant", sa_role, adb_schema

For SQL Server, log in as sa and then execute the following command before creating catalog tables for the external schema:

use master
EXEC sp_addsrvrolemember 'adb_schema', 'sysadmin'

For DB2 on IBM i/AS400, you can avoid table access problems by changing the ActiveDatabase user authority to *ALLOBJ.