Focal Point
[CLOSED]Report Caster Schedule transfer ownership

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3427019086

February 23, 2016, 11:20 AM
MikeW
[CLOSED]Report Caster Schedule transfer ownership
Hello,

We are trying to transfer ownership of multiple schedules in Report Caster. I tried following the documentation but the "Owner..." option doesn't do anything, nothing happens when I click it. I'm not sure if something wasn't setup correctly or not with our configuration. If there's no way on the front end to do this is there a backend way to make this update? I was able to update the CASTER_USER but that didn't move the schedule under my folder in report caster. Any help/advice would be appreciated. We are on version 8.1.05

Thanks!

This message has been edited. Last edited by: <Emily McAllister>,


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
February 23, 2016, 11:28 AM
Francis Mariani
From the default portal, or another portal that has the Resource tree, set the Administration to Mode Manager.

Then select and right-click on the schedule, navigate to Security and then Owner...

Do you not get a pop-up window where you can change the owner?

Perhaps this is due to some granular security setting that needs to be changed.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 23, 2016, 11:44 AM
Wep5622
We struggled enough with that that we eventually decided to change the ownership directly in the reportcaster database (ours is in MSSQL).

Just make sure that the user that you change those schedules to is indeed a user at the reporting server side and has sufficient privileges to run the schedule(s).


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
February 23, 2016, 11:50 AM
MikeW
I think you are correct about some granular security setting needing an update. I changed to Mode Manager, right-clicked on the schedule, navigate to Security and the only option is Effective Policy.

If I right-click the schedule, choose properties, the window pops up and I see the Security button at the bottom, then I click it, and I see the Owner option but nothing happens when I click it.

One last note, when I'm in the Report Caster Explorer the Owner column is blank for all the schedules. The Path is there, but I can figure out where to find the schedules and perhaps manually move them. I rather use the front end though.

Any ideas on more setting changes needed?

Thanks!


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
February 23, 2016, 11:52 AM
MikeW
Wep5622, I'm open to changing the ownership on the database but I'm having trouble finding what else I need to update. I did update the CASTER_USER on the BOTSCHED and BOTTASK tables but it didn't move the schedule. My guess is I'm not modifying the correct table???


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
February 23, 2016, 11:58 AM
Francis Mariani
Those columns are not part of the WebFOCUS Security layer


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 23, 2016, 12:01 PM
MikeW
Thanks Francis. Any idea on what tweaks I need to make to get the ownership option working?


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
February 23, 2016, 12:07 PM
Francis Mariani
I'm looking, but it requires a wizard to find this invisible needle in the haystack...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 23, 2016, 12:08 PM
MikeW
Thanks for looking. I'm continuing to research, if I find it I'll make sure to post back.


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
February 23, 2016, 12:09 PM
Francis Mariani
This is what you should see when you select Owner...




Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 23, 2016, 12:20 PM
Francis Mariani
In Security Center, for my User ID, I right clicked on my User ID and selected Security > Effective Policy (I also checked the Show all Privileges checkbox).

My User ID is in the Administrators group, so I have many Privileges, including "Assign Ownership", "Assign Ownership to Groups", "Assign Ownership to Users".

Perhaps changing the Effective Policy to "Permitted" for those three Privileges in the Administrators group will make this available to the User IDs in the Administrators group.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 23, 2016, 12:22 PM
Francis Mariani
You can verify if the Administrators have these privileges by right-clicking on Administrators group and selecting Security > Effective Policy (check the Show all Privileges checkbox when the list of privileges is shown).


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 23, 2016, 01:05 PM
MikeW
I think you are on to something. I did check and my User ID is in the Administrators group.

I right clicked on the admin group selected Security > Effective Policy. And there is nothing in the Users box or Privileges box. When I click Show all Privileges nothing still appears in both of those boxes.


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
February 23, 2016, 01:21 PM
Francis Mariani
There's something I've completely neglected, "Roles".

Unfortunate, I know nothing more. Let's hope a Security Wizzard checks in soon.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 24, 2016, 07:53 AM
CLH
Within Security center right click your administrators group select security and rules for this group. This would show you the group role/rules You can then click on the roles tab within security center and see what permissions that role has. Based on your description it seems your id is in an admin group that has restricted access but the above steps will let you check.

Crystal


Webfocus 8.0.7 on Windows
February 24, 2016, 03:03 PM
MikeW
Thanks Crystal. When I pick rules for this group the box appears but everything is blank, I just see the column headers like, Security, Access, Role, Apply to, Set On. Same thing if I select Rules on this resource.

If I pick just rules, then click on Administrator, I see a list of many things down in the Rules for Group - Administrators box. All have a value in the Access column of "Not Set". The only row that doesn't have Not Set is SystemFullControl. The Access column says Inherited =>, the Apply To says Inherited =>, the Inherited Rule column says 'Over Permitted' from 'IBFS:'
So for that list of Rules should I change one or multiple from Not Set to Permitted so Administrators are able to Transfer Ownership of caster schedules? Not sure which on that would be.


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
February 27, 2016, 01:37 PM
MikeW
I've tried just about every option I can think of and I still am not able to change the ownership of a users schedule. I did find where I could setup the Roles. I gave the role all the privileges possible. Right clicked on my User account, picked Rules, then picked the new role that has all the privileges necessary and still no ownership option. Logged out multiple times just to make sure. I also made sure the administrators group had this same access and my account is part of the administrators group. Any one have any ideas???

One strange thing I do notice is, If I go into Security Center, right click my user account, then Security, then pick "Rules for this user" I get the popup window but there's no rows there, just the column headers. However if I do the same thing on my account but pick just Rules, then click the Users tab, click my user account, I see in the "Rules for User" box at the bottom that new Role I created and the Access columns says Permitted. Kind of strange.

One last question, when I'm looking at the Security Center and the users list, my user account has the lock icon beside the little person icon, why is this?


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML