cancel
Showing results for 
Search instead for 
Did you mean: 

SAP GRC Access Control 12.0 upgrade - tables clean up

olgavlachova
Explorer
0 Kudos
1,288

Hello all,

we are running upgrade from GRC AC 10.0 to 12.0 and I would like to clean up some data during upgrade.

We will remain existing GRC Production as a read only standalone system for access to old data. That's why I want to delete obsolete synced content (done by Repository Synchronization, Action Usage Sync, Role Usage Sync, PFCG Sync) and roles in Business Role Management.

What tables should be cleaned up?

GRACUSER
GRACUSERCONN
GRACACTION
GRACACTIONSYST
GRACACTIONT
GRACACTPERM
GRACACTPERMSYS
GRACPROFILE
GRACPROFILET
GRACRLCONN
GRACRLCONNT
GRACRLCONNTXT
GRACRLCONNVAL
GRACROLEACT
GRACROLEACT_STG
  
GRACACTUSAGE
GRACROLEUSAGE
  
GRACROLE
GRACROLEAPPRVR
GRACROLEARC
GRACROLEAUTHCNT
GRACROLECRPVL
GRACROLEDEF_STG

What about logs like GRACCHANGELOG?

Thank you very much for ideas and help!

View Entire Topic
bassuino
Explorer
0 Kudos

Hello Olga,

Thanks for the details.

The synched data is gonna be deleted by the job mentioned above:

Authorization: GRACACTIONSYST, GRACACTPERMSYS, GRACAUTHPMSYST, GRACCLASSSYST, GRACFLDSYS, GRACFLDSYST, GRACFLDVALSYS, GRACOBJECTAUTH, GRACPERMCLSSYS, GRACPERMFLDSYS, GRACPERMFLDVAL

Repository: GRACRLCONN, GRACROLEORG, GRACUSER, GRACUSERCONN, GRACUSERMAP, GRACUSERORG, GRACUSERPROFILE, GRACUSERROLE, GRACUSRPDPROFILE, GRACPROFILE, GRACPDPROFILES, GRACPROFILET

Action Usage: GRACACTUSAGE, GRACMGMTACTUSAGE

Role Usage: GRACROLEUSAGE

Other: GRACTASKEXECSTMP

However, there`s other data connected to table GRACROLE such as workflows. Are you also planning to delete workflows and all master data involved in that?

Cheers,

Fernando