[This KA was unapproved and obsolete when migrated.] There is a database table created under a user X. For security reasons, the customer wants to publish/subscribe under the user Y. What should I do?
Article ID: KB0092072
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
Create a trigger on the source table under the user X, which will copy the inserted/updated/deleted row to the corresponding table under the user Y. (The destination table has to be created previously and is supposed to have the same structure as the source table). Then the adapter will run on this table (under the user Y).
To subscribe a table using an agent with a database account different from the account that created the table originally, you can put a trigger on the subscription table and copy to your target table under a different user.
Create a trigger on the source table under the user X, which will copy the inserted/updated/deleted row to the corresponding table under the user Y. (The destination table has to be created previously and is supposed to have the same structure as the source table). Then the adapter will run on this table (under the user Y).
To subscribe a table using an agent with a database account different from the account that created the table originally, you can put a trigger on the subscription table and copy to your target table under a different user.
Issue/Introduction
[This KA was unapproved and obsolete when migrated.]
There is a database table created under a user X. For security reasons, the customer wants to publish/subscribe under the user Y. What should I do?
Environment
Product: TIBCO Adapter for ActiveDatabase
Version:
OS:
--------------------
Feedback
Yes
No
Powered by
