GROUP_USER

When used outside stored routines, GROUP_USER returns the names of the groups to which the current user belongs.

If used within a stored routine created with EXTERNAL SECURITY DEFINER, however, GROUP_USER returns the groups to which the user who owns the schema of the routine belongs; this is usually the creating user, although the database owner could be the creator as well.

This function returns a string of up to 32672 characters.

Syntax

GROUP_USER

Example

splice> VALUES GROUP_USER;
1
--------------------------------------------------------------------
"VIEWERS", "EDITORS"

1 row selected

See Also