Design Master Security

[sturner333]

Haven't been able to find an answer to this in the literature. If I
replicate a database, can anyone else(other computer) modify the design master? So far I
haven't been able to figure out how to assign permission for this. Anyone else
opening the design master sees it as a replica.
Thanks for the help!

 

[scottian]

Not sure what you mean by "how to assign permission" or "Anyone else
opening the design master sees it as a replica"

But (im assuming this is what youre trying to do) what i do is to create a master db and place in a shared location and password protect it. Then create a copy and link all the tables to the master. This means that a user can update the master database but cant get into it. It also means that a user cant drag a copy of the database to their desktop, thinking they are making a shortcut, it doesnt matter whether they make a shortcut or a copy as the copy will still be linked to the master or the shortcut will open the shared db.

Hope i got your query right.

"My God! It's full of stars...