• 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