Remove user from role via SQL

• zsarv

  SSC Veteran

  Points: 287

  More actions

  February 13, 2012 at 3:54 pm

  #264505

  Hi All,

  I've got a case where I'm moving a database between different domains, and want to remove users from a predefined role before the move. I do not want to drop the role itself as it has all the permissions set up the way we need it.

  I've not been able to find the SQL to remove a specified user from a role easily. If anyone know of a concise method, it'd be greatly appreciated.

  Thanks!

• Colleen M. Morrow

  SSCrazy

  Points: 2457

  More actions

  February 15, 2012 at 1:40 pm

  #1447536

  To remove a user from a database role, use exec sp_droprolemember [rolename], [username].

  Colleen

  ---

  
  Colleen M. Morrow
  Cleveland DBA

• zsarv

  SSC Veteran

  Points: 287

  More actions

  February 15, 2012 at 2:12 pm

  #1447549

  Thanks so much. Glad it was an easy answer.