ADMIN
GROUPUSERS
GROUPUSERS | ||
---|---|---|
Name | USERNAME | GROUPNAME |
Type | VARCHAR | VARCHAR |
Indexed | x | x |
It returns the relationships between user names and group names.
All versions
For administrators, it returns all the records fr a given username or group name.
From 9.3.3
(Note: You might also want to read the PUBLIC.USERGROUPS table to efficiently write queries based on groups where the current user belongs)
Since the console access is now restricted to trusted users, a more relaxed security policy is applied to this table covering more real use cases without compromising data privacy.
For the current user, it returns all group names where the current user belongs to.
For any user, it only returns one record if the username belongs to the group name. Otherwise, no records. This is useful to compute other users’ records belonging to a particular group.
Example: This is is useful to write a query to compute only work logged by the users belonging to a particular group only.