Post reply

Replication Table Permissions

  • April 20, 2004 at 1:34 am

    #101969

    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 21, 2004 at 7:56 am

    #503639

    We also use replication extensively - between servers here and remotely - and yes, although users aren't dropped, the rights are trashed - a royal pain in the <your word here>.

    I have a master script generated from SQLEM, and edited to only apply users and rights to all databases.  After starting replication again, I use this script to reapply the users and their associated rights.

    Best practices should be to keep several scripts in a safe place so that objects can be recreated quickly:  A script to rebuild your databases, define tables and associated dependencies/indexes, and one for users and permissions.  I have one that does it all, one for each database, one that just does tables, and one that just handles users and permissions. 

    Hope this helps.

     

    -- Joe

  • April 22, 2004 at 12:49 am

    #503757

    Hi Grasshoper.

    Please send me the script

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply