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.
CA Asset Portfolio Management 14.x, 17.x
When the export runs against a view, it drops and re-creates the view.
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.