List all roles in the system:
SELECT group_name FROM dm_group WHERE group_class = 'role'
List all users who are members of this group, including those who are members of groups contained in this group:
SELECT i_all_users_names FROM dm_group WHERE group_name = ''
List all groups a particular user can modify:
SELECT group_NAME from dm_group WHERE group_admin = '' or owner_name = ''
Create a new group with an associated e-mail address and a specific list of members:
CREATE GROUP ABC WITH ADDRESS 'abc@docu.com' MEMBERS A,B,C
Create a new group list of members generated by a subquery:
CREATE GROUP supers MEMBERS (SELECT user_name FROM dm_user WHERE user_privileges >= 16)
Remove specific users from an existing group:
ALTER GROUP ABC DROP A,B
Add users from a subquery to an existing group:
ALTER GROUP ABC ADD (SELECT user_name FROM dm_user WHERE user_os_name LIKE '%%')
Delete a group from the repository:
DROP GROUP ABC