User Defined Functions - Replication -- sql server replication

Ton
7/21/2006 5:08:01 AM

Hi!

My user defined functions have permissions setup on a primary server.
Two users are allowed certain access. When I am replication the whole
database to another server those permissions are not being replicated
(despite of the fact that those users are defined on a destination
server).
If I go to a destination server (subscriber) and set permissions
manually(the way they are in production) - those permissions will
disappear once the replication is completed.

Ton
7/21/2006 7:42:01 AM

Tried to run script manually after replication and it still didn't work.

Thanks,
[quoted text, click to view]

Hilary Cotter
7/21/2006 9:18:49 AM

You can also apply them on all subscribers deployed via unc by using
sp_addscriptexec which will run a script on all subscribers. This way you
can modify them on an as needed basis.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]

Paul Ibison
7/21/2006 3:46:26 PM

What was the error returned?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : User Defined Functions - Replication