I have a SQL Database with different roles and users,depends upon their roles,permissions,they can see some table,views and etc.
Now,I am going to replicate (Snapshot) the same Database into different server.
My query is, in the source database incase if they do some changes in the roles,permissions,adding roles/updation of users happens, the same will be replicated in the destination databsase as well? One of my friend told
that ,snapshot replication just deals with records inside the Database and does not deal with users/roles/permissions...Is that so?
View Complete Post