I want to give dbo privlidge to a user but also want to assign deny on just dropping a database. Is that possible? tried deny on couple permissions didnt work.thanks
Database owner can drop the database that he owns, but I think that you can create a DDL trigger on the server level that will prevent dropping the database.