dhis2-users team mailing list archive

[Jim Grace <jimgrace@xxxxxxxxx>]

Hi Archana,

You can try patching the database with something like the following, then
either restart DHIS 2 (restart Tomcat), or go to Apps -> Data
Administration -> Cache Statistics -> Clear cache

insert into usermembership (organisationunitid, userinfoid) values (
(select organisationunitid from organisationunit where parentid is null),
(select userid from users where username = 'admin') );

This should result in admin being assigned to both the root and the Level 4
org unit. You can then go in and unassign the level 4 org unit if you like.

Cheers,
Jim


On Thu, Jan 21, 2016 at 8:16 AM, Knut Staring <knutst@xxxxxxxxx> wrote:

> I think you will have to do that directly in the database.
>
> On Thu, Jan 21, 2016 at 2:01 PM, Archana Chillala <
> archanac@xxxxxxxxxxxxxxxx> wrote:
>
>> Hi,
>>
>> On DHIS2, I have set up an organisational structure with 5 levels. The
>> admin user is assigned to ROOT Organisation Unit.
>>
>> Later, I assigned the admin to Level 4 Org. Unit and unselected the Root
>> Org. Unit.
>> The admin can now only see or access, the Org. Unit assigned and the ones
>> nested below.
>>
>> How can I re-assign the user to Root Organisation Unit ??
>>
>> I am using DHIS version 2.22
>>
>> Any suggestions??
>>
>>
>>
>> Thanks & Regards,
>>
>> Archana Chillala
>> Application Developer
>> Email archanac@xxxxxxxxxxxxxxxx
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>