Jack is the project administrator of a project prj1. The project involves a large volume of sensitive data including user IDs, shopping records along with the data mining algorithms with proprietary intellectual property rights. Jack wants to protect the sensitive data and algorithms and allow only project users to access the data within the project. He also wants to make sure that data flows within the project only.
use prj1; set ProjectProtection=true; --Enable the project data protection mechanism
Once the project data protection is enabled, data within the project cannot be transferred out of the project. All the data flows only within the project.
use prj1; add trustedproject prj2;