Hi, this is almost correct ;) The userroleauthorities table is a link table between userrole and authorities. So it will contain all available authorities only if you assume that all possible authorities have been assigned to one or more user roles.
So a hack is to create a new user role in the system with all possible authorities and then do: select distinct authority from userroleauthorities; Abyot, did you start on a document outlining the authorities? regards, Lars
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
