June 10, 2003 at 9:30 am
I am running SQL2000 SP3 on a win2k server.
I have 2 DBs on the server with one DB subscribing to the other (on the same server in this instance but eventually moved to sep. servers). I have set up each DB with the same users and set table level permissions. I have tried pushing and pulling a snapshot of the tables but whenever I do this the table level permissions are lost and no-one can get access. I can't find anything in MSDN or previous threads which mentions losing table level permissions....any ideas?
June 10, 2003 at 10:15 am
When you run the snapshot agent, SQL places shared locks in the tables that participate in the publication.
That mean that you can select the table, but not modifing then.
If you can't afford locking the tables, maybe you should choose transactional replication, wich allows to create the snapshot in concurrent mode. that is with out locking the tables.
June 11, 2003 at 12:45 am
The permissions are being permenantly lost, not temporarily. Until I manually go back into the subscribing database and update the permissions no-one can get access,
June 11, 2003 at 3:53 pm
Well, snapshot replication can drop and then recreate the tables. It 's just an option. So you might loose the permissions in here.
You can alter the publication to just delete the rows instead of dropping the table.
I would also check the files that the snapshot agent creates. All the .bcp files, sch files and idx files too.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply