Permissions and Ownership question when restoring db to local SQL Server Express

  • Hello all.

    I am going to request that our hosting and development company create a back up of one of our large databases. My goal is to restore it locally in my SQL Server Express 2012 so I can create some database diagrams. As it is now, I do not have permissions to create these diagrams as my role is not defined as an owner of any type/group.

    My concern is that if I restore an exact copy, all the roles, groups, permissions and restrictions will come with it. How do I know that when I restore it locally that I can essentially be the owner? I just just use Windows Auth to work with SQL Server Express locally.

    How do I know I won't be creating the same problem locally?

  • for your local SQL instance, I'm sure you are sysadmin of the box;

    that means any database you create or restore on that locla isntance will be under your umbrella, so you will not have any issues via permissions...your sysadmin powers will override whatever permissions might be contained inside the database that you are restoring.

    so to be clear, lets say you restore a database that you normally only have db_datareader rights, or even more restricted rights, like you can only see two views, and no tables at all

    if you restore the database on your local server where you are sysadmin, you will have full dbo rights...create,delete,drop, everything.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • OK. Thanks. Hope you're right. Will know soon enough.....

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply