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')