Rights problem after replication

Hello,
I've got a snapshot replication problem. My master database has some
tables which are replicated on 2 read-only databases. In every
database, I have the same roles, but not the same users. When I
replicate the database, every rights on my replicated tables are
erased ! What's the problem ?
Thanks for your help !!
Are you using SQL Server 2000? In this case you'll need a pre-snapshot script
to create the user if he owns any tables. If not the user and the permissions
can be in a post-snapshot script. For SQL 2005 there is a new option on
sp_addarticle (0x40000000) to add the permissions.
HTH,
Paul Ibison
|||On 31 mai, 11:23, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> Are you using SQL Server 2000? In this case you'll need a pre-snapshot script
> to create the user if he owns any tables. If not the user and the permissions
> can be in a post-snapshot script. For SQL 2005 there is a new option on
> sp_addarticle (0x40000000) to add the permissions.
> HTH,
> Paul Ibison
Hello and thank you for your quick answer !
Yes, I'm using SQL Server 2000. How can I create this pre-snapshot ?
I've already a sql file that contain the grant's list.
TIA, pem
|||On the snapshot tab in the publication properties there is an option to
browse for a TSQL file.
Cheers,
Paul Ibison