Friday, March 23, 2012

Permissions replication

I have setup replication from one SQL 2000 server to
another. All I am replicating is one single small DB.
The replication of the data seems to work fine. however,
permissions (both on public and a special user) are not
replicated.
I have been unable to find how/where to specify
replication op permissions. Any help on this will be
greatly appreciated.
Joe
use the post snapshot command, or you can always replicate it to all of your
subscribers by using
sp_addscriptexec.
What this proc will do it so replicate to and execute the script on all
subscriber.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Joe Bunker" <admin@.yearone.com> wrote in message
news:9bad01c478c4$b04cc1c0$a501280a@.phx.gbl...
> I have setup replication from one SQL 2000 server to
> another. All I am replicating is one single small DB.
> The replication of the data seems to work fine. however,
> permissions (both on public and a special user) are not
> replicated.
> I have been unable to find how/where to specify
> replication op permissions. Any help on this will be
> greatly appreciated.
> Joe
|||Hi Hilary,
I've had inconsistent results with sp_addscriptexec - running on some
subscribers but not others (no anonymous) - particularly if a subscriber was
not connected at the time the command was run.
Have you experienced this at all?
Cheers,
Mary
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:O5bzLYMeEHA.596@.TK2MSFTNGP11.phx.gbl...
> use the post snapshot command, or you can always replicate it to all of
your
> subscribers by using
> sp_addscriptexec.
> What this proc will do it so replicate to and execute the script on all
> subscriber.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Joe Bunker" <admin@.yearone.com> wrote in message
> news:9bad01c478c4$b04cc1c0$a501280a@.phx.gbl...
>
|||Hilary,
Do you have any more information on the post snapshot
command? And/or a sample permissions script to use with
either sp_addscriptexec or @.post_snapshot_script?
Thank you.

>--Original Message--
>use the post snapshot command, or you can always
replicate it to all of your
>subscribers by using
>sp_addscriptexec.
>What this proc will do it so replicate to and execute the
script on all[vbcol=seagreen]
>subscriber.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Joe Bunker" <admin@.yearone.com> wrote in message
>news:9bad01c478c4$b04cc1c0$a501280a@.phx.gbl...
however,
>
>.
>
|||no, I have not. sp_addscriptexec is pooled in the distribution database and
it should be executed on ALL subscribers that are subscribed to the
publication.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mary Bray" <reply@.tonewsgroup.com.NOSPAMPLEASE> wrote in message
news:OYlm2MVeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary,
> I've had inconsistent results with sp_addscriptexec - running on some
> subscribers but not others (no anonymous) - particularly if a subscriber
was
> not connected at the time the command was run.
> Have you experienced this at all?
> Cheers,
> Mary
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:O5bzLYMeEHA.596@.TK2MSFTNGP11.phx.gbl...
> your
>
|||for a permissions script connect to your database using EM. Right click on
the publication database, and select all tasks, generate SQL Script. In the
general tab, select the objects whose permissions you want to replicate, and
in the options tab, select Script Object Permissions.
Then generate the script, and edit it to remove all object creation/drop
statements until all that is left is the Grant and Deny commands.
Then save this script and this is the script you should propagate to all
subscribers.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Joe Bunker" <anonymous@.discussions.microsoft.com> wrote in message
news:b78001c4797c$c1fe9890$a401280a@.phx.gbl...[vbcol=seagreen]
> Hilary,
> Do you have any more information on the post snapshot
> command? And/or a sample permissions script to use with
> either sp_addscriptexec or @.post_snapshot_script?
> Thank you.
> replicate it to all of your
> script on all
> however,
sql

No comments:

Post a Comment