Tuesday 6 August 2013

Migrating User Profiles, Permission Lists and Roles

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

2 comments:

  1. How do you migrate the data for these records from one Instance to another if the PeopleTools versions are different.

    ReplyDelete
  2. This 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