Recall that our very simple scenario is to only allow email@example.com access to the birthday party event and ensure that no other events are accessible. You may find it helpful to refer back several pages to the database schema diagram to follow which data we are inserting and why.
We have already included a file named data.sql in the sample application. All of the SQL explained in this section will be from the file—you may feel free to experiment and add more test cases based on the sample SQL we've provided—in fact, we'd encourage that you experiment with sample data!
Let's take a look at the following steps for creating a simple ACL entry:
- First, we'll need to populate the ACL_CLASS table with any or all ...