SQL rights to DB export view are being dropped

Document ID : KB000093687
Last Modified Date : 02/05/2018
Show Technical Document Details
Issue:
Have a search that is scheduled to export to a view each day. The view is set to Never Expire. We have one SQL Server with permissions to use this view; however, their permissions are dropped after the view populates each day. 
Environment:
CA Asset Portfolio Management 14.x, 17.x
Cause:
When the export runs against a view, it drops and re-creates the view. 
Resolution:
The sql view is dropped and recreated so that the search criteria can be modified without having to create a new export search.
This behavior is by design, so that users do not have to recreate the export each time the search criteria changes.

One possible solution:
Create a stored proc to grant select permissions for the login to the export view only, and run this procedure after the export scheduled job has completed it's daily run.