Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-01 : 08:31:54
|
| Debbie writes "When doing snapshot replication, the table permissions are dropped on the subscriber articles(table). For example, UserID1 on AccountTable,Server1 has Select and Insert permission before replication is performed. After replicating AccountTable from Server2(which has the identical permissions) to Server1, the permissions on the Server1 table are gone. I'm using the replication wizard to set this up and I can't find anything during the setup that references permissions. I have read the online books, searched your site, read your FAQ's, and consulted two books. My replication is successful other than dropping the permissions. This also happens when I replicate within the same server. Any idea what would cause this?" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-11-01 : 11:50:27
|
| I think it is standard for that to happen. We use transactional replication and the same thing happens.I believe i read somewhere that it is something to do with security.You can script up object level permissions on server2 and run the script on the subscriber(server1). Right-click on database then All tasks then generate SQL scripts then click on the options tab and it should be apparent.===========Paul |
 |
|
|
|
|
|
Permissions dropped from Snapshot Replication