Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transactional Replication Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 1:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 6:45 AM
Points: 243, Visits: 773
What are the permission required to configure Transactional Replication?
Post #1442630
Posted Tuesday, April 16, 2013 4:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 6:32 AM
Points: 12, Visits: 126
YOu require the Clustered index for transactional replication

Rajesh Singh
DBA(HCL Comnet)
+91-0560888360
Post #1442668
Posted Tuesday, April 16, 2013 2:56 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:16 AM
Points: 811, Visits: 1,161
What kind of answer it is? He is asking for permission required to create Transactional replication.

Only members of the sysadmin fixed server role can set this up from end to end.
because adding publisher would require that.

But members of db_owner fixed database role can execute sp_addpublication, & sp_addsubscription.
Post #1443018
Posted Wednesday, April 17, 2013 4:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 7:44 AM
Points: 10, Visits: 53
For initial setup of any replication like transactional, you need sysadmin permissions. However, most of the things you can do with Database Owner permissions once the replication is setup. Like, adding\removing subscriptions, add\modify articles etc can be done using Database owner permissions.

Post #1443171
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse