Reset to original org unit

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?

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@gmail.com 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@lists.launchpad.net

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