PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/05/2016 8:48 AM by  Greg Moeller
Export of user rights?
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Greg Moeller
Private
Private
Veteran Member
(3873 points)
Veteran Member
Posts:1377


Send Message:

--
12/18/2015 3:31 PM
    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    01/04/2016 3:03 PM
    Anyone??
    Matthew Nye
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    01/04/2016 4:49 PM
    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 = &#39;&#39;A&#39;&#39;
    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    01/05/2016 8:48 AM
    Thanks, Matthew! Although we haven't tried importing yet... I've got your code returning values here.
    You are not authorized to post a reply.