• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 1498
Veteran Member
5/1/2015 3:51 PM
Yes, please!
JeanneS
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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?