Accidentally deleted a view in RSA IGL 7.0.2, how to recreate the view, any ideas?
Accidentally deleted a view in RSA IGL 7.0.2, how to recreate the view, any ideas?
pv_data_access_collector
If you have access to another environment, you can get the SQL from there (screenshot below)
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AVUSER"."PV_DATA_ACCESS_COLLECTOR" ("NAME", "ID", "COLLECTION_COUNT", "ERROR_COUNT", "DESCRIPTION", "CREATION_DATE") AS
SELECT NAME, T_DATA_COLLECTORS.ID, COLLECTION_COUNT, ERROR_COUNT, DESCRIPTION, CREATION_DATE FROM T_DATA_COLLECTORS, T_AV_DATA_ACCESS_COLLECTORS WHERE T_DATA_COLLECTORS.ID = T_AV_DATA_ACCESS_COLLECTORS.ID AND IS_DELETED = 'FALSE' WITH READ ONLY ;
COMMENT ON TABLE "AVUSER"."PV_DATA_ACCESS_COLLECTOR" IS 'Lists all data access collectors created in ACM';Thanks much that helps...
Which view did you drop?