Tell me more ×
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.
up vote 2 down vote favorite

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

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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