Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-30 : 08:45:51
|
| Tim writes "Sysinfo: SQL2K, Win2K Servers. All patches and service packs applied (they are kept current daily).I have a master database inside a firewall, and a website/SQL server outside the firewall. I want to use transaction replication to copy and update a part of the master database to the webserver (i.e. no immediate or queued updates coming back from the webserver, it's just a read-only database without other sensitive data to help prevent potential hacks). I have the website using stored procedures for all data access.I can get everything to replicate fine, and data updates are flowing from the master to the subscriber; but the SPs that the website uses to read the DB do not replicate with permissions, so I have to manually set all the permissions on about 50 SPs before it will work. In other words, before replication I set up a blank DB to accept the subscription; set up matching users and roles in it; and then apply the snapshot and subscription. The tables and SPs move over okay but do not include any user or role permissions. I really don't want to manually update permissions every time I renew or reinitialize the subscription. Don't permissions replicate?Thanks,Tim" |
|
|
|
|
|
Replicating SP permissions