Page Comparison

...

SELECT 
    * 
FROM 
  ADMIN.GROUPS
WHERE
 NAME LIKE '%zephyr%'

Checking

For example, if you want only the users belonging to the zephyr-testers group can see the data you have to check if the current user belongs to it:

...

Note how the USERGROUPS table returns the same GROUPNAME if the user belongs to the group and it returns no records otherwise.

This allows to easily and efficiently dropping records if the current user does not belong to the group.

...