How can grants on the subscription database be configured to match grants on the publication database?
By default, replication does not execute GRANT statements on the subscription database. If you want the permissions on the subscription database to match those on the publication database, use one of the following methods: • Execute GRANT statements at the subscription database directly. • Use a post-snapshot script to execute the statements. For more information, see Executing Scripts Before and After the Snapshot Is Applied. • Use the stored procedure sp_addscriptexec to execute the statements.
Related Questions
- I don have a subscription to one or more of the subscription database websites (Ancestry, Footnote, WorldVitalRecords, etc.). How else can I access these databases?
- How can grants on the subscription database be configured to match grants on the publication database?
- What is the cost for a subscription to the online database?
