Hi,

I have succesfully setup a transactional replication between two sql server databases. But now I still need to have the object-level permissions replicated properly, ie: the permissions on SP, tables and views.

I know there is one way of doing it and that is have a script generated on the source database which generated all the GRANT EXECUTE statements. Unfortunately I need to have this script build up periodically without me having to do it every time again.

So my question is: can this script build-up be scheduled so I would have a fully automated object-level permissions replication script?

Thanks!