Hi Devs, I’m just following up again on the queries about new/retired authorities that I raised about a month ago (please see bottom of this thread). This is becoming very urgent as PSI approaches its upgrade to 2.25.
I’m wondering if the silence is because there isn’t a single person on the Dev team who is able to answer all of the questions below? If that’s the case, would it perhaps be possible for anyone on the Dev team to chime in with notes on just the specific authorities that they’ve worked on? Many thanks for any help you can provide, Regards, Sam. From: Sam Johnson <[email protected]> Date: Monday, 27 February 2017 at 18:57 To: Lars Helge Øverland <[email protected]> Cc: DHIS2 Developers <[email protected]>, Rodolfo Melia <[email protected]>, JM Alcantara <[email protected]> Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22) Hi Devs, I’m just following up on the questions below regarding authority changes in 2.25, which I circulated a few weeks ago (see the items highlighted in red). There’s unfortunately no documentation on authorities, so I’d be very grateful for any help you’re able to give. Many thanks, Sam. From: Dhis2-devs <[email protected]> on behalf of Sam Johnson <[email protected]> Date: Wednesday, 15 February 2017 at 12:57 To: Lars Helge Øverland <[email protected]> Cc: DHIS2 Developers <[email protected]> Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22) Hi Lars, Many thanks, that’s a really useful trick – takes less than half the time it took me to scrape the authorities! :-) Are you (or is someone else on the team) able to assist with the questions in my email below? (I know the email is quite long, so I’ve just highlighted them in bold red.) Many thanks, Sam. From: Lars Helge Øverland <[email protected]> Date: Wednesday, 8 February 2017 at 03:58 To: Sam Johnson <[email protected]> Cc: DHIS2 Developers <[email protected]>, JM Alcantara <[email protected]>, "[email protected]" <[email protected]> Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22) Hi Sam, thanks for bringing this up. It is an issue we need to handle better. There is a trick to finding the complete set of authorities per version. · Start up a DHIS instance of the desired version. · Create a new user role, give it the name AAA, and select all available authorities, click Save. · Then execute this SQL: select ua.authority into _auths from userroleauthorities ua inner join userrole ur on ua.userroleid=ur.userroleid where ur.name<http://ur.name> = 'AAA'; You can repeat the process on the target DHIS 2 version instance, and then copy the tables into a single database and use SQL (..where not in..) to compare them. You can also save this to a file and compare using CSV/Excel: psql -d dhis2 -U dhis -c "select * from _auths" > auths.txt We can also work on this on our side and include pruning of obsolete authorities in a DHIS startup routine. best, Lars On Tue, Feb 7, 2017 at 2:37 AM, Sam Johnson <[email protected]<mailto:[email protected]>> wrote: Hi Devs, If possible, I’d be very grateful for some advice around authorities in 2.25. In order to help prepare for PSI’s upgrade to 2.25, we’ve done an analysis of changes in Authorities between 2.22 and 2.25. I couldn’t find a database table containing Authorities, and the list of Authorities in the DHIS2 documentation doesn’t appear to have been updated since version 2.22, so I’ve scraped the ‘Authorities’ drop-down in the ‘Create Role’ screen to obtain lists of Authorities in 2.22 and 2.25 for comparison. The following Authority changes seem fairly straightforward, and were documented as part of DHIS2 releases: RETIRED (functionality no longer exists) • View data browser • See Data Set Maintenance module • See Organisation Unit Maintenance module • Scheduling case aggregate query builder INTRODUCED (new functionality) • Delete External Map Layer • Add/Update Private External Map Layer • Add/Update Public External Map Layer • Add/Update Legend • Delete Legend • Delete Legend Set • Add/Update Private Legend Set • Add/Update Public Legend Set • Metadata sync • Add/Update Predictor • Delete Predictor • Delete Program Indicator Group • Add/Update Private Program Indicator Group • Add/Update Public Program Indicator Group • Add/Update Push Analysis • Delete Push Analysis • See Usage Analytics module I’m guessing the following Authorities have been retired because they duplicate existing (more refined) Authorities? Could you confirm whether this guess is correct? RETIRED AS REDUNDANT?: • Option Set Management • Constant Management DO THESE EXISTING AUTHORITIES MAINTAINED IN 2.25 PROVIDE THE SAME PERMISSIONS? • Delete Option Set • Add/Update Private Option Set • Add/Update Public Option Set • Add Constant • Delete Constant I’m not sure what the following new set of Authorities govern – I’ve looked at Option Sets (as distinct from Category Option Group Sets), but can’t find any concept of ‘Groups’ in Options/Option Sets… What do these new authorities control? INTRODUCED • Delete Option Group • Add/Update Private Option Group • Add/Update Public Option Group • Delete Option Group Set • Add/Update Private Option Group Set • Add/Update Public Option Group Set The following appear to have been RETIRED prior to the 2.25 release – could you confirm that these Authorities have indeed been retired (rather than just missed off the drop-down of Authorities in the ‘Create Role’ screen)? If they have been retired, which Authority now manages these permissions? RETIRED? (AND REPLACED BY?) • Add Relationship Type – now covered by ??? • Delete Relationship Type – now covered by ??? • Scheduling send messages – now covered by ??? • Add/Update Section – now covered by ??? • Delete Section – now covered by ??? • Add/Update Tracked Entity – now covered by ??? • Delete Tracked Entity – now covered by ??? • Manage Tracked Entities – now covered by ??? • Update Tracked Entities – now covered by ??? • Delete Tracked Entity Attribute – now covered by ??? • Add/Update Private Tracked Entity Attribute – now covered by ??? • Add/Update Public Tracked Entity Attribute – now covered by ??? • Manage Tracked Entity Instance Reminders • M_dhis-web-menu-management We’d be very grateful for any advice or feedback you can provide on the questions above, as it would be a huge help in adjusting our own Roles to ensure permissions work smoothly during our 2.25 upgrade. (Once the dust has settled on our 2.25 upgrade, I’d also be very happy to re-do this exercise for 2.26, and share it with this Dev list.) Many thanks, Sam. Samuel Johnson - Consultant ————————————————— Qebo Ltd 288a Gloucester Rd, Bristol BS7 8RP Phone: +44 7734 960 923<tel:+44%207734%20960923> _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected]<mailto:[email protected]> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
