• sqlfriends (4/18/2013)


    Can this account itself add himself as a dbowner right after the database is restored?

    Two things ...

    DBCreator is a server role. dbowner is a database role. So you are talking about two different roles, different security levels.

    If you want the same account (or group) be part of dbowner Immediatly after being restored, add that user to model and make it part of dbowner group. Next time when your job creates the database, it will also contain the user or group and will be part of dbowner.