GRAC_DELETE_ACCESS_RULES and Synchronization data

[former_member618409]

Is it safe to delete synchronization data of a connector? Is it critical data? What are the circumstances where there is a need to delete synchronization data?

[madhusap]

Hi Redjie,

All the tables you have mentioned gets updated when you execute the sync job "GRAC_PFCG_AUTHORIZATION_SYNC". When you execute the mentioned sync job, GRC system will bring the authorization data (which includes authorization objects, fields, values etc.) from your target system to GRC.

Deleting or Archiving the sync data does not help as even after you delete/archive, the same data is going to get synced from your target system to GRC when the sync job "GRAC_PFCG_AUTHORIZATION_SYNC" is run. In case you are no longer connecting GRC system to some of the target systems, you can consider to delete/archive the data in the sync tables as the sync data from those target systems is obsolete.

Otherwise, if these tables are causing any performance issues then you may need to assess from your overall hardware sizing perspective and also should reach out to SAP support for their recommendation.

Regards,

Madhu

[madhusap]

Hi Redjie,

Can you let us know why you are planning to delete the Sync Data?

As the word suggests it is Synchronization data i.e. this data is coming from your target system and even if you delete in GRC system, you can execute sync jobs to bring the data back into GRC system.

Generally lot of reports data in GRC is also based on the synchronization data and hence if you delete the sync data then those reports might not show any data. Generally i do not see any requirement to delete the sync data unless the data is corrpupted which is very unlikely.

Regards,

Madhu

[former_member618409]

Thank you, Madhu. There is an initiative in our team to cleanup or reduce the size of some of the large tables in our database. The tables are GRACPERMFLDVAL, GRACACTPERMSYS and GRACPERMFLDVALG which total to 25GB of disk space. According to SAP note 2268795, the data on these tables fall under synchronization data.

Can you tell me what is the sync job that can restore the data once deleted? Also, what are the reports that need this data? Thank you in advance.