Because EDC carries the potential for data loss or corruption due to unintended updates, we recommend the following precautions:
1. Use a test instance of a database whenever testing EDC-enabled Rulesheets from Studio. If unintended changes or deletions are made during rule execution, then only test database instances have been changed, not production databases.
2. Even if using test instances, you may still want to restrict the ability to read and update connected databases to those users who understand the possible impact. For other rule modelers without a solid understanding of databases, you may want to provide them with read-only access.
3. As you approach production, you might want to reserve the ability to Create/Update Database Schema to a small set of senior administrators as that action drops database tables.