Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to create a user having dbcreate, db restore server roles and will be db owner of that database. But there is only 1 server roles available that is dbcreator, which can create database is also db owner of that. But when I restore another database backup that gets disconnected, i.e. not accessible.

In sql server is there any way that can create and restore db and will be dbowner of that database. I don`t want to grant sysadmin server roles to that user.

Please help me out.

share|improve this question
    
I haven't tested it, but GRANTing "ALTER ANY DATABASE" in addition to dbcreator might do the trick. –  TToni Sep 6 '12 at 14:23
add comment

migrated from stackoverflow.com Oct 1 '12 at 2:32

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.