April 20, 2004 at 1:41 am
I posted this by mistake at the wrong place, please bear with me:
Is there a way to replicate the table permissions from publisher to
subscriber? I noticed that when replication takes place, the permissions
that were set up on tables on the subscriber are wiped out. I need the permissions to be send to the subscriber automatically.
April 20, 2004 at 7:17 am
No. Permissions are not saved at table level, because depends on users and roles. So you can replicate permisions of a table.
You can try to copy roles and users with DTS to transfer permissions of objects to users.
April 20, 2004 at 7:45 am
Racosta, i have run a DTS to transfer the permissions, and whatif the DBA decides to change the permissions of the users on the Publisher, what will let me know about it so that i can run the DTS again, i need something that will do this process automatically
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply