I have a merge replication in my SQL Server 2008.
I'm replicating some views, and I can't find an option to copy permissions for it, while tables, stored procedures and user-defined functions have this option.
I see only "Copy extended properties" option, but, as I know, this option is for view diagram.
I found "permissions on the view are not getting replicated", but this is a SQL Server 2012 issue.
Is there any possibility to copy it, cause I don't like workaround for issue above?