How do I replicate permissions for articles in a merge repl publication?
I've read that if you replicate the syspermissions table, the permissions
will follow the objects, but I can't figure out how to view/include a sys
table when defining the articles.
I've generated a 'set permissions' script that I manually run on the
subscriber, but if that ends up being the only way I can set permissions on
the subscriber, how can I automate that process - as I will have appx 10-15
non-concurrent subscribers.
Thanks for any/all help!
Jeff Jones
Atlanta, GA
Wow! Where did you read that?
You need to replicate them as part of a post snapshot command. You can keep
them in sync by manually scripting out the permissions and applying them
through sp_addscriptexec if you are applying your snapshots as a file copy
(unc). This won't work with snapshots deployed via ftp.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"J Jones" <JJones@.discussions.microsoft.com> wrote in message
news:D98AEB7A-2F71-40F6-A93E-0D15DF8EB123@.microsoft.com...
> How do I replicate permissions for articles in a merge repl publication?
> I've read that if you replicate the syspermissions table, the permissions
> will follow the objects, but I can't figure out how to view/include a sys
> table when defining the articles.
> I've generated a 'set permissions' script that I manually run on the
> subscriber, but if that ends up being the only way I can set permissions
> on
> the subscriber, how can I automate that process - as I will have appx
> 10-15
> non-concurrent subscribers.
> Thanks for any/all help!
> Jeff Jones
> Atlanta, GA
|||Thanks Hillary - that helps a bunch. Here's a link to the syspermissions
mention that I made:
http://www.mssqlcity.com/FAQ/Replic/...ermissions.htm
I like your solution much better! Thanks again!
Jeff
"Hilary Cotter" wrote:
> Wow! Where did you read that?
> You need to replicate them as part of a post snapshot command. You can keep
> them in sync by manually scripting out the permissions and applying them
> through sp_addscriptexec if you are applying your snapshots as a file copy
> (unc). This won't work with snapshots deployed via ftp.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "J Jones" <JJones@.discussions.microsoft.com> wrote in message
> news:D98AEB7A-2F71-40F6-A93E-0D15DF8EB123@.microsoft.com...
>
>
|||Basically he is suggesting the same thing that I am, only I am ever so more
eloquent than him
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"J Jones" <JJones@.discussions.microsoft.com> wrote in message
news:8E1165FF-B62C-4A27-86A7-46B946576FE7@.microsoft.com...[vbcol=seagreen]
> Thanks Hillary - that helps a bunch. Here's a link to the syspermissions
> mention that I made:
> http://www.mssqlcity.com/FAQ/Replic/...ermissions.htm
> I like your solution much better! Thanks again!
> Jeff
> "Hilary Cotter" wrote:
|||OK, so I added the Snapshot pre- and post- scripts (pre to initialize some
UDFs, and post to set permissions), but I'm getting the following error:
The schema script '\\RMPPLUS2SQL01\E$\Program Files\Microsoft SQL
Server\MSSQL\ReplData\unc\RMPPLUS2SQL01_ResiDD_RES IFLD2_RESIFLD2\20051215104323\InitializeCompliancU DFs_0.sql' could not be propagated to the subscriber.
I had no trouble propagating the Replication scripts. Now that I've added
the pre-snapshot script, it's no longer working. Any ideas?
Jeff
"Hilary Cotter" wrote:
> Basically he is suggesting the same thing that I am, only I am ever so more
> eloquent than him
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "J Jones" <JJones@.discussions.microsoft.com> wrote in message
> news:8E1165FF-B62C-4A27-86A7-46B946576FE7@.microsoft.com...
>
>
