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? 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.

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.