...
Grouper's views can be granted to schemas to make it possible to access Grouper data from SQL.
Notes/Warnings
- If you do grant Grouper views to schemas you should keep track of what you grant to do some sanity tests on Grouper upgrades.
- Some views are for reporting reasons and are not intended for real time data.
- Check the views that you use to see the performance.
- The SQL interface is useful for large loads that might overwhelm or not be performant or not be possible in web services.
- This SQL interface is for SELECT only, not insert/update/delete, and is not used with the Grouper API, just SQL queries in whatever programming language you would like. Ask the Grouper team for help if you are not sure how to use the tables
...