:D Minimum Permissions an SQL user is required for a Sync

vivusvivus Posts: 6
edited January 4, 2006 1:14PM in SQL Toolkit Previous Versions
Maybe i have been looking in the wrong places, but I'm looking for the minimum requirements for a user/role to have in order to do a schema sync and a data sync without using sa or being logged in a windows account with admin privileges..

any help would be greatly appreciated.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    I'm afraid there is no easy answer to this one, but I can give you some pointers. It's easiest if you have sysadmin rights. Without sysadmin, you cannot decrypt encrypted objects. Next, you can be a dbo in the database, which would be the next best thing. Speaking with more granularity, you'll need alter rights on any object that need to be altered and create rights on the particular types of objects that need to be created.

    Probably the easiest thing to do (on SQL 2000 anyway) is to give your user db_ddladmin. This builtin role was designed by Microsoft for modifying database schema.
Sign In or Register to comment.