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
------------