When a user has to delete one Connector/System from GRC the syncs jobs will not remove from the tables the data from this connector,
but there is a report GRAC_DELETE_ACCESS_RULES that do the job, if you select the last check box as you can see in image:
You will delete data from the selected connector for the following GRC tables, *Noticed that all this tables has connector field and if this field is equal the connector that was choose the data will be erased.*
- gracactionsyst
- gracactpermsys
- gracactusage
- gracauthpmsyst
- gracclasssyst
- gracfldsys
- gracfldsyst
- gracfldvalsys
- gracmgmtactusage
- gracobjectauth
- gracpdprofiles
- gracpermclssys
- gracpermfldsys
- gracpermfldval
- gracprofile
- gracprofilet
- gracrlconn
- gracroleorg
- gracroleusage
- gractaskexecstmp
- gracuser
- gracuserconn
- gracusermap
- gracuserorg
- gracuserprofile
- gracuserrole
- gracusrpdprofile
- gracclasssyst
- gracfldsyst
- gracfldvalsys
- gracprofile
- gracroleorg
- gracroleusage
- gracusermap
- gracuserorg
- gracactionsyst
- gracactpermsys