Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Default Report Permissions

 10 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
9/17/2014 1:31 PM
    Hi!

    Does anyone know which table holds the Default Permissions for reports?

    We have been struggling with intermittent issues where the 'Ability to view with refresh data and view with saved parameters' gets unchecked. And we're really looking for a way to audit all of those default permissions.

    Thanks in advance,
    -Greg
    TammyT
    Basic Member
    Posts: 5
    Basic Member
    5/1/2015 3:19 PM
      Did you figure anything out with this one? Since we upgraded to LBI 10.4 in mid March, we've had our Default Permissions mysteriously disappear 4 times already. We don't know how or why that keeps happening. Anyone have any ideas?
      JeanneS
      Veteran Member
      Posts: 49
      Veteran Member
      5/1/2015 3:29 PM
        We had the same thing happen shortly after we upgraded to LBI 10.4. The report permissions for ability to view report with data refresh and ability to export a report default permissions disappeared. I opened an incident with Infor but did not get a resolution.
        JeanneS
        Veteran Member
        Posts: 49
        Veteran Member
        5/1/2015 3:31 PM
          We also had a lot of Reporting Services schedules disappear. Has anyone else had this issue?
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          5/1/2015 3:37 PM
            We've had report schedules disappear with just about every upgrade.. and we don't know about some of them for months.
            JeanneS
            Veteran Member
            Posts: 49
            Veteran Member
            5/1/2015 3:45 PM
              This is the first time we noticed so many disapearing all at once. I created a Smart Note that runs daily to show me any schedules that were deleted. I can give you the query that I used if you are interested.
              Greg Moeller
              Veteran Member
              Posts: 1498
              Veteran Member
              5/1/2015 3:51 PM
                Yes, please!
                JeanneS
                Veteran Member
                Posts: 49
                Veteran Member
                5/1/2015 3:58 PM
                  I created a condition in the Smart Note to show if there were deleted items. The query below is what I used for the Infoset using a JDBC query.

                  SELECT "EJS_TRIGGERS"."CALENDAR_NAME", "EJS_TRIGGERS"."DESCRIPTION", "EJS_TRIGGERS"."END_TIME", "EJS_TRIGGERS"."IS_VOLATILE", "EJS_TRIGGERS"."JOB_GROUP", "EJS_TRIGGERS"."JOB_NAME", "EJS_TRIGGERS"."MISFIRE_INSTR", "EJS_TRIGGERS"."NEXT_FIRE_TIME", "EJS_TRIGGERS"."PREV_FIRE_TIME", "EJS_TRIGGERS"."START_TIME", "EJS_TRIGGERS"."TRIGGER_GROUP", "EJS_TRIGGERS"."TRIGGER_NAME", "EJS_TRIGGERS"."TRIGGER_STATE", "EJS_TRIGGERS"."TRIGGER_TYPE"
                  FROM "RSUSER"."EJS_TRIGGERS" "EJS_TRIGGERS"
                  TammyT
                  Basic Member
                  Posts: 5
                  Basic Member
                  5/1/2015 5:23 PM
                    Yes! We too are having report schedules disappear with 10.4. I just opened an incident this week with Lawson, but again, no resolution yet. I think it has happened in the past, but it has happened at least 3 times since we upgraded to 10.4 in mid March. Thank you for the sql query! That will be a handy Smart Note to have.
                    Greg Moeller
                    Veteran Member
                    Posts: 1498
                    Veteran Member
                    5/1/2015 6:49 PM
                      Thank you so much for the SQL. Very helpful to have this SN built and in place.
                      Greg Moeller
                      Veteran Member
                      Posts: 1498
                      Veteran Member
                      6/16/2015 2:26 PM
                        JeanneS: Sorry, but we are a bit confused about your sql. Can you/would you share/screen shot your condition with the group?