I have a created custom Database Role called Managers. Added db_owner to this role. I would like to Deny DROP Database to this custom Role. But the DENY Drop DATABASE TO Managers is not working

Any work around ?

  • 1
    Can you post your exact code? – SQLRockstar Mar 6 '14 at 4:07
  • Are read/write permissions not sufficient ? – Kin Shah Mar 6 '14 at 4:07

The roles db_owner and sysadmin are special cases and can't be denied anything. My guess is that db_ddladmin, db_datareader, db_datawriter and execute access will give you everything you want instead of using db_owner.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.