Security and Replication
You cannot implement database security on replicated databases. You can only implement user-level security. All the replicas inherit the security applied to the Design Master. Replicate only the database file. Never replicate the security information file (System.mdw). Instead, make sure that exactly the same security information file is available at each location where the replica is used. You can do this by copying the file to each location.A user must have administrator permission on a database to perform the following tasks:
- Converting a nonreplicable database into a replicable database
- Making a replica of the Design Master
- Making a local object replicable
- Making a replicable object local