db_ddladmin permissions to be revoked

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  July 13, 2011 at 12:31 am

  #254402

  Fellas, I created a role and assigned db_ddladmin to this role. Now if I want to remove the db_ddladmin access from my created role, what should be the query. I tried looking in BOl but could not get the right one.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  July 13, 2011 at 12:24 pm

  #1352361

  Try sp_droprolemember 'your role', 'db_ddladmin'

  Greg