How to modify privileges for objects in the default Cache Datasource?
book
Article ID: KB0076032
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
7.0 and higher
Description
Scenario:
You are encountering a TIBCO Data Virtualization (TDV) permissions error from the attempted use of one of the cache tables found under /lib/sources/defaultCacheDataSource. Typically this would be an error concerning the lack of sufficient permissions for a user to either READ or SELECT from the cache table.
In your attempt to remedy this, you find that the privileges for these cache tables cannot be modified, as the TDV Studio UI is either grayed out or inactive.
Resolution
This inactive privileges UI seen in the TDV Studio is by design, as these cache tables are normally owned by the TDV 'system' user and no other TDV user is able to manually update the privileges directly for these resources.
In order to modify the privileges of the cache tables seen under defaultCacheDataSource, you must alter the privileges of the cached base resource (a TDV view, datasource table or SQL Script procedure) and allow that action to propagate the same privileges to the cache table under defaultCacheDataSource. After modifying the privileges for the base resource, you must then toggle and SAVE the "Enable" checkbox seen in the upper left corner of the base resource's Caching tab, in the Studio's modeler screen. That toggling will immediately propagate the privileges into the cache table.
Rerun your query and verify the result.
Issue/Introduction
How to modify privileges for objects in the default Cache Datasource?