Table permissions being removed on transactional replication -- sql server replication

Johnny
8/26/2005 11:55:08 AM

I found it odd that randomly, some of the table permissions at the subscriber
of a transactional publication are removed after distribution.

I've been testing the distribution of a transactional publication and
occasionally when the distributor runs, it removes the security permissions
on the table. I found this to be odd, specially since it is not consistent.
FYI, I am not referring to the initial snapshot, instead, the ongoing updates.

Is this normal? If so, I guess I should configure the replication to
re-apply the permissions at the subscriber every time the distributor runs,
right?

Hilary Cotter
8/27/2005 6:13:32 AM

Its not normal. Table permissions are not replicated - you will need to
deploy them via a sp_addscriptexec (for unc subscribers only), or when your
snapshot is applied via a post snapshot command.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : Table permissions being removed on transactional replication