(private) sorry...!! contact@ecmnotes.com

Groups and Roles

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

Leave a Reply