What happens to permissions granted in a subscription database if a subscription is reinitialized?
By default, objects at the Subscriber are dropped and recreated when a subscription is reinitialized, which causes all granted permissions for those objects to be dropped. There are two ways to handle this: • Reapply the grants after the reinitialization using the techniques described in the previous section. • Specify that objects should not be dropped when the subscription is reinitialized. Prior to reinitialization, either: • Execute sp_changearticle or sp_changemergearticle. Specify a value of ‘pre_creation_cmd’ (sp_changearticle) or ‘pre_creation_command’ (sp_changemergearticle) for the parameter @property and a value of ‘none’, ‘delete’ or ‘truncate’ for the parameter @value. • In the Article Properties –
Related Questions
- Under the Will of the Testator, a beneficiary was granted a right to reside. What happens to the land tax liability in respect of that land?
- What happens to permissions granted in a subscription database if a subscription is reinitialized?
- What happens after the subscription expires (one year normally)?
