Want to migrate User Profiles, Permission Lists and Roles, here are the tables you would need.
Below are the tables related to User Profiles:
PSOPRDEFN
PSOPRALIAS
PSROLEUSER
PSUSERATTR
PSUSEREMAIL
PSUSERPRSNLOPTN
PS_ROLEXLATOPR
PS_RTE_CNTL_RUSER
Below are the tables related to Roles:
PSPRSMPERM
PS_BCHCLASSDEFN
PS_IB_CHNL_SEC_AET
PSAUTHBUSCOMP
PSAUTHCHNLMON
PSAUTHCUBE
PSAUTHITEM
PSAUTHMP
PSAUTHOPTN
PSAUTHPRCS
PSAUTHQUEUEMON
PSAUTHSIGNON
PSAUTHWS
PSCLASSDEFN
PSOPROBJ
PSPRCSPRFL
PSPURGEPERMLIST
PSROLECLASS
PS_RUN_CNTL_SCRTY2
PS_RUN_CNTL_SCRTY6
PS_SCRTY_ACC_GRP
PS_SCRTY_QUERY
PS_SJT_CLASS
PS_SJT_CLASS_ALL
PS_SJT_CLS_TMP
PS_SJT_OPR_CLS
PS_SJT_OPR_CLS_TMP
PS_MC_OPRID
PS_MC_OPR_SECURITY
Below are the tables related to Permission Lists:
PS_APPR_RULE_ROLE
PS_CREATEUSER_AET
PS_DYNROLE_TMP
PS_EOEC_MP_ROLE
PS_EOEC_MP_ROLE_CI
PS_EOEC_MP_ROLRULE
PS_EO_DSROLERULE
PS_FPMSCTYACTN_TBL
PS_GP_RSLT_ADM_ROL
PS_HCR_SM_PSEC_TBL
PS_HCR_SM_RSEC_TBL
PS_HRS_JO_RCTR_RL
PS_OPER_ROLE_DEFN
PS_OPER_ROLE_DFLTS
PSCDBACTSEC
PSCDBROLEUSER
PSROLECANGRANT
PSROLECLASS
PSROLEDEFN
PSROLEDEFNLANG
PSROLEDEFNL_RMT
PSROLEDEFN_RMT
PSROLEGROUP
PSROLEPERM_RMT
PSROLEUSER
PSROLEUSER_RMT
PS_PTAFAW_AUTH_DTL
PS_PURGE_ROLEDEFN
PS_ROLEUSER_ARCH
PS_ROLE_LDAPRULE
PS_ROLE_PPCRULE
PS_RTE_CNTL_RUSER
PS_RTE_CNTL_RU_ARC
PS_SCCPS_CNTXT_TLS
PS_SCC_SI_ROLE
Below are the tables related to User Profiles:
PSOPRDEFN
PSOPRALIAS
PSROLEUSER
PSUSERATTR
PSUSEREMAIL
PSUSERPRSNLOPTN
PS_ROLEXLATOPR
PS_RTE_CNTL_RUSER
Below are the tables related to Roles:
PSPRSMPERM
PS_BCHCLASSDEFN
PS_IB_CHNL_SEC_AET
PSAUTHBUSCOMP
PSAUTHCHNLMON
PSAUTHCUBE
PSAUTHITEM
PSAUTHMP
PSAUTHOPTN
PSAUTHPRCS
PSAUTHQUEUEMON
PSAUTHSIGNON
PSAUTHWS
PSCLASSDEFN
PSOPROBJ
PSPRCSPRFL
PSPURGEPERMLIST
PSROLECLASS
PS_RUN_CNTL_SCRTY2
PS_RUN_CNTL_SCRTY6
PS_SCRTY_ACC_GRP
PS_SCRTY_QUERY
PS_SJT_CLASS
PS_SJT_CLASS_ALL
PS_SJT_CLS_TMP
PS_SJT_OPR_CLS
PS_SJT_OPR_CLS_TMP
PS_MC_OPRID
PS_MC_OPR_SECURITY
Below are the tables related to Permission Lists:
PS_APPR_RULE_ROLE
PS_CREATEUSER_AET
PS_DYNROLE_TMP
PS_EOEC_MP_ROLE
PS_EOEC_MP_ROLE_CI
PS_EOEC_MP_ROLRULE
PS_EO_DSROLERULE
PS_FPMSCTYACTN_TBL
PS_GP_RSLT_ADM_ROL
PS_HCR_SM_PSEC_TBL
PS_HCR_SM_RSEC_TBL
PS_HRS_JO_RCTR_RL
PS_OPER_ROLE_DEFN
PS_OPER_ROLE_DFLTS
PSCDBACTSEC
PSCDBROLEUSER
PSROLECANGRANT
PSROLECLASS
PSROLEDEFN
PSROLEDEFNLANG
PSROLEDEFNL_RMT
PSROLEDEFN_RMT
PSROLEGROUP
PSROLEPERM_RMT
PSROLEUSER
PSROLEUSER_RMT
PS_PTAFAW_AUTH_DTL
PS_PURGE_ROLEDEFN
PS_ROLEUSER_ARCH
PS_ROLE_LDAPRULE
PS_ROLE_PPCRULE
PS_RTE_CNTL_RUSER
PS_RTE_CNTL_RU_ARC
PS_SCCPS_CNTXT_TLS
PS_SCC_SI_ROLE
How do you migrate the data for these records from one Instance to another if the PeopleTools versions are different.
ReplyDeleteThis would require fit-gap analysis. Once the functional expertise is involved in fetching the relevant details, you can go ahead with different modes of data conversions like - App Engine, SQR, Datamover scripts, Datalink (if suitable).
ReplyDelete