User Groups Functions
memberOf(String username, String groupName) checks whether a username is a member of a group.
Example: how to check whether the currentUser is member of a group:
select
memberof((select jira from aux.currentuser), 'jira-core-users') as "memberOf"
from
dual