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 toadb_schema
grant drop any trigger toadb_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
.