on 2023 Mar 27 3:16 PM
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!
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.