User Groups Functions

Owned by Pablo Beltran (Unlicensed)
Last updated: Feb 27, 2020 by Pablo Beltran
  • 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