SyncFX仅适用于具有DbOwner权限的用户 [英] SyncFX only works for Users with DbOwner Permissions

问题描述

任何其他具有读写访问权限的用户都会在尝试枚举表中进行更改时收到错误。 我已经将用户设置为具有EXECUTE以及READ和WRITE。

解决方案

不确定您正在使用哪个提供程序，但这里是数据库的一些安全注意事项在Sync FX中访问：

 

对Sync Framework用于读取和写入元数据表和基表的所有存储过程的EXECUTE权限。

元数据表的SELECT，INSERT，UPDATE和DELETE权限以及将在同步会话期间更新的任何基表。

当您配置SQL Server时使用SqlSyncProvider的数据库，请注意以下配置权限要求：

CREATE TABLE权限以启用元数据表的创建：scope_info和scope_config，以及为每个创建的跟踪表基表。

ALTER TABLE将触发器添加到基表。

创建PROCEDURE权限以创建Sync Framewo的过程rk需要。

scope_info和scope_config表的SELECT和INSERT权限。

基表的SELECT权限。

 

Any other users with Read and Write access get error trying to enumrate the table for changes.  I have set user to have EXECUTE as well as READ and WRITE.

解决方案

not sure which provider you're using but here's a some security considerations for database access in Sync FX:

 
EXECUTE permissions on all the stored procedures that Sync Framework uses to read and write to metadata tables and base tables.

SELECT, INSERT, UPDATE, and DELETE permissions for metadata tables and any base tables that will be updated during a synchronization session.

When you provision SQL Server databases that use SqlSyncProvider, be aware of the following permissions requirements for provisioning:

CREATE TABLE permissions to enable creation of the metadata tables: scope_info and scope_config, and the tracking tables that are created for each base table.

ALTER TABLE to add triggers to the base tables.

CREATE PROCEDURE permissions to create the procedures that Sync Framework requires.

SELECT and INSERT permissions for scope_info and scope_config tables.

SELECT permissions for base tables.

 

这篇关于SyncFX仅适用于具有DbOwner权限的用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！