Export of user rights?

Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
    Looking for anyone with experience in exporting existing LBI rights.
    We are in the middle of configuring our upgrade including a server update and a platform upgrade.
    We have a lot of rights and would hate to manually enter all of them again.
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      Anyone??
      Matthew Nye
      Veteran Member
      Posts: 514
      Veteran Member
        Greg,
        give this is a shot. should atleast get you started:

         SELECT DISTINCT 
        ERS_RULEMASTER.RULENAME
        , ERS_RULEMASTER.RULEID
        , ERS_RULEVALUES.STRUCTUREID
        , ERS_RULEVALUES.ELEMENTID
        , ERS_STRUCTURE.STRUCTURENAME
        , ERS_ELEMENTS.ELEMENTNAME
        , ERS_RULEVALUES.ELEMENTVALUE1
        , ENPUSERMAP.USERNAME
        FROM ERS_RULEMASTER ERS_RULEMASTER 
        	INNER JOIN ERS_RULEVALUES ERS_RULEVALUES ON ERS_RULEMASTER.RULEID = ERS_RULEVALUES.RULEID
        	INNER JOIN ERS_RULEDETAIL ERS_RULEDETAIL ON ERS_RULEMASTER.RULEID=ERS_RULEDETAIL.RULEID 
        	INNER JOIN ERS_STRUCTURE ERS_STRUCTURE ON ERS_RULEVALUES.STRUCTUREID = ERS_STRUCTURE.STRUCTUREID
        	INNER JOIN ERS_RULEMAPPINGS ERS_RULEMAPPINGS ON ERS_RULEDETAIL.RULEID=ERS_RULEMAPPINGS.RULEID
        	INNER JOIN ERS_ELEMENTS ERS_ELEMENTS ON ERS_RULEVALUES.ELEMENTID = ERS_ELEMENTS.ELEMENTID
        	INNER JOIN LawsonFS.ENPUSERMAP ENPUSERMAP ON ERS_RULEMAPPINGS.CONSUMERID = ENPUSERMAP.EXTERNALUSERNAME
        WHERE TRUNC(ERS_RULEMASTER.STARTDATE) <= TRUNC(sysdate)
        	AND TRUNC(ERS_RULEMASTER.ENDDATE) >= TRUNC(sysdate)
        	AND ERS_RULEMASTER.STATUS = ''A''
        ORDER BY RULENAME, USERNAME, STRUCTURENAME, ELEMENTNAME, ELEMENTVALUE1
        If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
          Thanks, Matthew! Although we haven't tried importing yet... I've got your code returning values here.
          ---