dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Try this:

insert into usermembership
select ou.organisationunitid,u.userid from organisationunit ou
 cross join users u where parentid is null and username='admin'

On Mon, Mar 14, 2016 at 10:24 PM, moses mwale <isoftcom.ic@xxxxxxxxx> wrote:

> I accidentally gave admin admin user, user by organisation specific
> districts removed it from parent org. How do i set it back to have parent
> org units?
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org