Alter Group : Add or Remove Users to a Group using DQL

Below is the query to add a User to a Group

Syntax

ALTER GROUP <GROUP NAME> ADD <USER NAME>

OR 

ALTER GROUP <GROUP NAME> ADD (<QUERY>)

Example

ALTER GROUP dctmgurusgrp ADD DCTMAdmin

OR 

ALTER GROUP dctmgurusgrp ADD (select user_name from dm_user where user_login_name = 'dctmadmin')

Below is the query to Drop/Remove a User to a Group

Syntax

ALTER GROUP <GROUP NAME> DROP <USER NAME>

OR 

ALTER GROUP <GROUP NAME> DROP (<QUERY>)

Example

ALTER GROUP dctmgurusgrp DROP DCTMAdmin

OR 

ALTER GROUP dctmgurusgrp DROP (select user_name from dm_user where user_login_name = 'dctmadmin')