Re: [Dhis2-devs] SQLview - protected tables

2018-03-13 Thread Calle Hedberg
Hi, Yes, the main user tables are protected. If you have access to the "backend" database, you can bypass it using a construct (query/function) that "re-packages" the user table information so that it can be accessed via sql view. Works, but obviously it creates a security risk (the main user

[Dhis2-devs] SQLview - protected tables

2018-03-13 Thread Himanshu Ardawatia
Hi, Getting the following error while trying to get user list for a given organization unit in sql view: "SQL query contains references to protected tables" The query is here: --- SELECT userinfo.surname, userinfo.firstname, organisationunit.name FROM public.usermembership,