Column-based security assignment is dropped in TIBCO Data Virtualization

Column-based security assignment is dropped in TIBCO Data Virtualization

book

Article ID: KB0075973

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.x and higher

Description

I created a Column-Based security policy, and assigned the policy to a view. The assignment no longer appears in the Web Manager. What could be the reason that the assignment was removed?

Issue/Introduction

Column-based security assignment is dropped in TDV (TIBCO Data Virtualization)

Resolution

An assignment is dropped if a column (that the assignment depends on) has been removed from the view. To illustrate, consider the following setup:
 
(1) A view vTest contains the following SQL:

          select  ANNOTATION, DATASOURCE_NAME
          from  /services/databases/system/all_datasources
 
(2) The column DATASOURCE_NAME is assigned to a Column-Based security policy named  MyColumnPolicy.
 
(3) If we edit the view's SQL to remove the DATASOURCE_NAME column:

          select  ANNOTATION
          from  /services/databases/system/all_datasources
 
Then, the assignment for DATASOURCE_NAME will be dropped and the following deassign message will be written to the Events log to indicate that the assignment has been removed.
 
------------
cs_server_events.log:2020-03-03 15:53:03.273 -0800 INFO DeAssign CBS Assignment /policy/cbs/MyColumnPolicy has been removed from Resource /shared/joe/vTest Column DATASOURCE_NAME 20 admin composite 22017 6333118333097 6333118333097 /shared/joe/vTest 
DATASOURCE_NAME /policy/cbs/MyColumnPolicy
------------