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.I believe that is not part of the snapshot. However, you can script it and make it the post snapshot script.|||Can yoy give me the script or recommend a side with the script because that exactly what i am looking for and can't figure it out as is not discussed on microsoft help|||http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replmon_9pwh.asp for reference.|||Satya, i don't see anything to do with permissions on the website you send me|||As per the BOL :
How to script replication (Enterprise Manager)
At the Publisher, open SQL Server Enterprise Manager, expand a server group, right-click the Replication folder, and then click Generate SQL Script.
Select the replication component to script (Distributor properties, publications and push subscriptions, or pull subscriptions) and whether you want the script to enable or create the components or disable or drop the components. .
HTH|||I am sorry about this Satya, but i can see only the logins granted for my publicatiom on my Publisher/Distributor, my question is how do you take those permissions automatically to the subsciber?
Showing posts with label permissions. Show all posts
Showing posts with label permissions. Show all posts
Wednesday, March 28, 2012
Friday, March 9, 2012
replication of permissions
What do I have to do in SQL 2000 to replicate permissions?
Depends on the exact scenario, but I use a post-snapshot script to replicate
permissions for initialization. For subsequent changes to permissions, I use
sp_addscriptexec.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||thanks Paul.
Depends on the exact scenario, but I use a post-snapshot script to replicate
permissions for initialization. For subsequent changes to permissions, I use
sp_addscriptexec.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||thanks Paul.
Labels:
database,
microsoft,
mysql,
oracle,
permissions,
replicate,
replication,
server,
sql
Subscribe to:
Posts (Atom)