How can we help you today? How can we help you today?

Permissions

I'm getting an error whenever I try to sync to a database where my user login has limited permissions.
The error is :
Denied permission for SELECT on object 'syslogins', database 'master', owner 'dbo'

The problem is I don't want to sync users, just data on my tables. Using this same account and a previous version of datacompare I can connect to the same db without any problem.

Is there any way to solve this and allow the sync to work?
Thanks
Vicenç
vmasanas
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello,

    I suspect that since version 5 of Data Compare shares some of the same components with SQL Compare, this issue has come up. The new components retrieve the schema information in much the same way in both SQL Compare and Data Compare. This normally doesn't happen unless the databases are locked down in an extremely paranoid way.

    In this case, I can't suggest any workarounds that would help.
    Brian Donahue
    0
  • vmasanas
    The problem is that with version 3.3.9 (both sql and data compare) this works. And I don't see this is such a paranoid way of security, just the user is ddladmin, not dbo.
    This is a very common setup in ISPs so this feature is a must when you have to replicate data/structure to a solution hosted on an internet provider.
    vmasanas
    0
  • Brian Donahue
    In this case, we are not referring to the rights in the database you want to compare. We are talking about your rights in the master database for the system. It looks like your provider has taken away everyone's rights to user attributes.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.