Does anyone know for sure how the sp_changegroup procedure behaves in IQ? I know in ASE the proc will change the group a user is a member of. In ASE only one group is allowed per user. However, I understand that IQ allows users to be members of multiple groups. In IQ does sp_changegroup simply add the user to the group or does it also remove the user from other groups?