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
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,
2 matches
Mail list logo