• Perry Whittle (2/6/2016)


    DBADave (2/5/2016)


    It is a database owner, not a database creator, and not a local admin.

    Tis the same thing, db_owner provides the power to backup and restore the database, restore implies create database.

    As Gail said, Db_owner is basically sysadmin at the database level, so avoid granting it.

    I believe the db_owner role can even drop the database. They can't recreate it, but they have permission to drop it.

    I admit I never thought of it that way, but I like the way Gail put it - sysadmin at a database level. I think that description fits very well.