View Issue Details

IDProjectCategoryView StatusLast Update
0005527SymmetricDSBugpublic2022-11-30 19:34
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.12 
Target Version3.12.20Fixed in Version3.12.20 
Summary0005527: Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission
DescriptionIt isn't possible to set up SQL Server log-based replication without the user having the "ALTER ANY DATABASE" permission. This becomes a problem when using Cloud SQL because it does not allow access to a user with the necessary permissions to grant this permission. It should be possible to pass this permission check if the user has enabled change tracking and snapshot isolation.
TagsNo tags attached.

Relationships

related to 0005528 closedemiller Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission 
related to 0005529 closedemiller Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 c7bea523

2022-10-12 18:42:47

evan-miller-jumpmind

Details Diff
0005527: Allowed SQL Server log-based replication without ALTER ANY DATABASE permission Affected Issues
0005527
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DatabasePlatform.java Diff File

Issue History

Date Modified Username Field Change
2022-10-12 15:45 emiller New Issue
2022-10-12 15:45 emiller Status new => assigned
2022-10-12 15:45 emiller Assigned To => emiller
2022-10-12 15:47 emiller Issue cloned: 0005528
2022-10-12 15:47 emiller Relationship added related to 0005528
2022-10-12 15:48 emiller Relationship added related to 0005529
2022-10-12 18:54 emiller Status assigned => resolved
2022-10-12 18:54 emiller Resolution open => fixed
2022-10-12 18:54 emiller Fixed in Version => 3.12.20
2022-10-12 19:00 Changeset attached => SymmetricDS 3.12 c7bea523
2022-11-30 19:34 admin Status resolved => closed