Problems with read only (db_datareader) user trying to sync
paule123
Posts: 44
Source database: 64-bit SQL Server 2008 R2 on Windows 2008 R2 Ent
Destination: 32-bit SQL Server 2008 R2 on Windows 2003 Ent 32-bit
When a SQL user with db_datareader only access to the source database tries to sync to the destination, various warnings will appear, such as about triggers being encrypted or individual fields being encrypted. Calculated fields will fail. We don't use encryption on our db. If I specify a SQL user with db_owner permissions to the source db, everything works as it should.
Destination: 32-bit SQL Server 2008 R2 on Windows 2003 Ent 32-bit
When a SQL user with db_datareader only access to the source database tries to sync to the destination, various warnings will appear, such as about triggers being encrypted or individual fields being encrypted. Calculated fields will fail. We don't use encryption on our db. If I specify a SQL user with db_owner permissions to the source db, everything works as it should.
Comments
That sounds about right. You have to be a sysadmin on the source server to decrypt objects because you need access to the keys and permissions to dump pages out of the database.