...
Code Block | ||
---|---|---|
| ||
SELECT * FROM ADMIN.GROUPS WHERE NAME LIKE '%zephyr%' |
NAME |
---|
zephyr-testers |
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.
...