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 <[email protected]> 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 : [email protected] > 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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
